Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

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 ? –  iDevlop Jun 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:

http://www.scootersoftware.com/moreinfo.php?zz=screenshot&shot=DataCompare

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.