Compare two workbooks and find differences

[GolfAnyone?]

We have a need to compare two workbooks, which have identical structures, to determine which names have been added and which have been removed. Each workbook has multiple sheets which would need to be compared. Any suggestions would be greatly appreciated!

 

[Steeviee]

If it's not too much hassle, and you have a spare column at the end of each page, you can use something like:
=countif([Book2]Sheet1!$A$2:$A$10000,A2)
(You just higlight the range of data in the second sheet)
You can then filter on all of the zeros - they have been added.
Then do the same thing in the other book (Book2 in my example) and all of the zeros will give you the deleted data.

You can just drag down the formula. If it's a one off operation, this is probably easier than trying to write a macro...