Solved

Compare 2 Excel Worksheets looking for changes and additions

Posted on 2012-03-29
7
355 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

896 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now