Solved

Compare 2 Excel Worksheets looking for changes and additions

Posted on 2012-03-29
7
371 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

820 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