Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Compare 2 Excel Worksheets looking for changes and additions

Posted on 2012-03-29
7
Medium Priority
?
401 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 46

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 46

Accepted Solution

by:
aikimark earned 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 46

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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…

916 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