comparing two excel documents

[Guest]

How can I compare the data in two excel documents other than manually
comparing or arranging the two files on the screen?

Word has that option of comparing two documents but I can't seem to find it
in Excel.

I have Excel 2000 and am running XP Home.

Yvonne

 

[David McRitchie]

Hi Yvonne,
Some links to macros in
Compare Excel Worksheets and Workbooks
http://www.mvps.org/dmcritchie/excel/comparexl.htm

it's pretty old I can see that one of the links is no good.