Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Compare 2 Excel Worksheets looking for changes and additions

Posted on 2012-03-29
7
Medium Priority
?
397 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

715 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