Comparing two excel worksheets
Hello all
I hope someone can help with my query as I'm currently struggling to overcome it.
I have an excel spreadsheet with 3 worksheets. Worksheet 1 has a list of all the records on our database and Worksheet 2 has a list of all the records on our database that are out of date. I want to compare the two worksheets and then list any records that are NOT on both of the worksheets in a list on Worksheet 3.
I am trying to design a macro to look at column A (which has the customer reference numbers) on both Worksheets 1 and 2 and when it finds any non-duplicates it copies the entire row and pastes it into Worksheet 3. The rows in Worksheets 1 and 2 have slight differences even if the customer reference number is the same, so I need to compare just the customer reference number rather than the whole row but then copy the entire row after it finds non-duplicates. I hope that makes sense..
I hope someone can help. Many thanks for your time.
|