Hi,
The easiest & quickest way I know for doing a "one off" check (if the
sheets are small or expected to be very similar eg both sorted
alphabetically etc) is to insert a new spreadsheet in the file (or in
one of the files if the 2 sheets are in separate files) that the 2
sheets are in.

In cell A1 of the new sheet type "=" and then select cell A1 of one of
the 2 existing sheets with the mouse, type "=" again, select cell A1 of
the other existing sheet with the mouse & press [enter]. This will
result in a formula similar to below:

='Other Sheet'!B55='Original Sheet'!A1

and will result in either "TRUE" if they are the same or "FALSE" if
they are different. Copy cell A1 down as many rows & across as many
columns as needed to cover all the data & then use Find to search for
the "false" values.

If the sheets are expected to be quite different or may have had rows
inserted the above technique is not very helpful. In that case check
out the bottom of Chip's page below which describes how to "Extract
Values On One List And Not Another":

http://www.cpearson.com/excel/duplicat.htm


hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=521292