Comparing workbooks

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

tinsel10

Thread Starter
Joined
Dec 13, 2004
Messages
17
Need to compare 2 similar workbooks where slight changes have been made to the second workbook. Would like Excel to highlight the changes so that they can then be corrected in the original workbook.

Is there any way of doing this in Excel 2003?
 

OBP

Joined
Mar 8, 2005
Messages
19,896
How many cells in how many ranges?
It can be done in VBA but it may be a bit slow if you have vast amounts of data to check.
 
Joined
Jul 25, 2004
Messages
5,458
Can you post a small sample of your workbook? Without more data, it's about like shooting in the dark..
 

tinsel10

Thread Starter
Joined
Dec 13, 2004
Messages
17
I have found the Compare and Merge feature and I am currently testing whether that will do the job. Will get back to let you know. Thanks
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top