Start by looking here
http://www.mvps.org/dmcritchie/excel/duplicates.htm

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

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Jonny" wrote in message
...
I have received two (unshared) versions of a very large workbook. I have
audited the first one for integrity, but my client has subsequently made
many
amendments.
Apart from comparing side by side (which is tedious), is there any way I
can
quickly identify the amendments made?