Hi,

I have two workbooks each with around 20 worksheets in
them. The names of the worksheets are identical. Each
worksheet has 13 columns with about 50 rows of data. One
workbook is the original workbook, the second has been
modified by the client. We could not use the track
changes feature because of the shared facility being used
and other issues. We thoroughly investigated that option
first.

We now need to identify which rows on which sheet contain
changed data. The data could be simply changed,or it could
be deleted or added rows. I have thought of importing
into acces then running a query but hope that there migt
be a VBA way of looping through the rows comparing one
book to the other.

I have been trying rowdifferences, but this does not seem
to be the right use of that command.

Any thoughts gratefully received.


Regards

David C