This question came from our site for professional and enthusiast programmers.

Well, there are many ways to go about this. Depends on how big your lists are, if you need it automated and so on. I would suggest combining the lists on one sheet and using excel's built in remove duplicates. You could of course automate this with VBA.
– ScottJun 18 '12 at 17:40

Do you need to account for inserted or deleted rows?
– Tim WilliamsJun 18 '12 at 17:44

4

What code did you produce ? What is the programming question ?
– Patrick HonorezJun 18 '12 at 20:28

1 Answer
1

If your spreadsheets are structured in the same way (i.e. the worksheets are named the same in each workbook and the data to be compared is in the same row/column) then the excellent Beyond Compare can do a file comparison on the two and show you the differences. More info here: