The challenge I am presented with is this:

I have two spreadsheets where I need to compare one column of data from each spreadsheet.

  1. How do I do the comparison and have the same numbers from both represented in a third cleaned up spreadsheet or within the column itself? Or

  2. How do I create a macro to eliminate the differences?

migrated from stackoverflow.com Jun 19 '12 at 13:59

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. – Scott Jun 18 '12 at 17:40
  • Do you need to account for inserted or deleted rows? – Tim Williams Jun 18 '12 at 17:44
  • 4
    What code did you produce ? What is the programming question ? – Patrick Honorez Jun 18 '12 at 20:28

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:


Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.