Comparing Excel Files

[Amr Tabbarah]

Does anyone know about a Macro or Add-in that compares 2 Excel
files/sheets in a similar manner to Compare in Word?

Thanks.

 

[Jay]

Does anyone know about a Macro or Add-in that compares 2 Excel
files/sheets in a similar manner to Compare in Word?

One way is to save two sheets as CSV files and use Word to compare the CSV
files. (It's awkward, but it gets the job done.)

 

[BrianB]

1. One method I like is to make a third sheet to show differences an
put a formula like this in all cells :-
=Sheet1!A1-Sheet2!A1 ....for numbers
=IF(Sheet1!A1<>Sheet2!A1,"Different","")

2. There are macros/addins available. I think I have seen the
somewhere like MVP or other Excel websites. Try searching the web

 

[Dave Peterson]

One version that does the cell by cell comparison is at Chip Pearson's site. It
was written by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

But if the OP has inserted/deleted rows/columns, then this will show lots of
differences.

 

[Jay]

1. One method I like is to make a third sheet to show differences and
put a formula like this in all cells :-
=Sheet1!A1-Sheet2!A1 ....for numbers
=IF(Sheet1!A1<>Sheet2!A1,"Different","")

This works fine for some kinds of differences, but doesn't handle well
things like an inserted row. Word works better if there might be inserted
or deleted rows or columns.