Solved

Compare 2 Excel Worksheets looking for changes and additions

Posted on 2012-03-29
7
363 Views
Last Modified: 2012-04-04
Hi, I could use some help comparing two Excel spreadsheets.  The purpose it to keep up on my college's ever-changing class schedule.  

The columns will always be the same.  Rows can be added and data in existing rows can be changed.

Example:  I would start with File 1 and add some columns at the end with my own notes.
The following week I would receive File 2 containing changes and additions.  

I want to get those changes/additions into File 1 so I can maintain my notes but have the most current information.

"Class" is the column that should be used to match on.    

Highlighting the changes made would be good too.
example of changes to file
0
Comment
Question by:BEBaldauf
  • 4
  • 3
7 Comments
 
LVL 45

Expert Comment

by:aikimark
ID: 37787397
1. What do you want to do about the prior changes?  For example, if you have changes noted/highlighted in your notes worksheet and you import the new version of the schedule, then how are the prior changes' highlights supposed to be treated?

2. Do you have to keep your notes in the same worksheet as the schedule data?

3. How do you use this change data?
0
 

Author Comment

by:BEBaldauf
ID: 37788035
To simplify the problem at hand, let's skip the whole issue of highlighting what gets changed.  If I could just get the changed data incorporated into my original document that would be awesome.
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 37788053
That is why I asked you about the location of your notes.  The simplest solution would be to replace sheet1 with the latest copy and keep your notes in sheet2 with the key (class value) being use to get at the current version of the course data.
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:BEBaldauf
ID: 37788066
What a great (an obvious!) solution!  Could you help me with an example, assuming my notes would be in 4 or 5 columns to the right of the data.  Thanks!!!
0
 
LVL 45

Expert Comment

by:aikimark
ID: 37788785
Please post your current notes workbook.

I'm leaving town for the weekend and may not be able to look at this until Sunday.  In the mean time, another expert may post a solution.

It would be helpful if you let us know how you used this, providing us with the context in which to offer you solution(s).
0
 

Author Comment

by:BEBaldauf
ID: 37806692
After pondering my question, I think I'll be able to do a simple vlookup based on the unique class number column.

I appreciate your assistance, and I think I'll call this one "answered"!
0
 

Author Closing Comment

by:BEBaldauf
ID: 37806699
A terrific, non-technical answer based on a new set of eyes on my problem.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question