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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Yvonne" <khariatdiscussions.microsoft.com wrote in message ...
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