Compare two Excel docs.

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Is there an easy way to do a "compare" of two excel docs,
similar to what can be done with word, that will just
highlight the differences between the two? I run a weekly
database report that gets imported into excel, and I need
to be aware of only the things that have changed from week
to week. Any ideas? Thanks.
 
Tim

You can use a 3rd workbook to compare the 2 workbooks. In
cell A1 of Book3 put in a formula similar to
=[Book1]Sheet1!A1=[Book2]Sheet1!A1
and copy to cover required fields. The result will be a
TRUE / FALSE result. You can then check the FALSE results.


Tony
 
Tim

The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.

http://www.cpearson.com/excel/whatsnew.htm

Look for Compare.xla.

Download Compare.xla and add it with rest of your your add-ins.
On Tools Menu, select add-ins and check in (tick in)Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top