How do I compare two workbooks that are not shared?
 

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?

How do I compare two workbooks that are not shared?
 

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?

How do I compare two workbooks that are not shared?
 

If you didn't insert or delete any columns or rows, you can use an addin
developed by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

Remember that this does a cell-by-cell comparison. A1 compares to A1, x99 to
x99, etc.

Jonny wrote:

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?

--

Dave Peterson