If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.
Ivano wrote:
Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.
Thanks,
--
Dave Peterson