Cell by cell comparison?
A1 with A1, Q12 with Q12, AC232 with AC232?
If yes, then you could use a program written by Myrna Larson and Bill Manville.
You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
======
If that's not it (you may have inserted/deleted rows or columns) can you pick
out a nice unique field in each worksheet?
If yes, then maybe you can use =vlookup() or =index(match()) to retrieve the
values from one worksheet and put them into helper columns on the other.
Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.
