Compare Two Sheets and Highlight Differences

Hi Guys,

I have been given a task at work which I am having trouble coming up with a suitable solution for and wondered if someone may have done this before or could recommend a VBA approach.

I am trying to compare two sheets within the same workbook (Sheet1 = New and Sheet2 = Old)

Both sheets contain user records in col A

I don't want to change anything in the New Sheet, but I want to compare the user records with the old records and if there are any updates, deletions/modifications between the records, I want to highlight them in yellow on the New sheet. It might also be good to extract any records which have changed to another Sheet so I can identify how many records have changed. Does this sound possible?

I have attached a workbook to demonstrate the data.

Any help would be welcomed. Many thanks for looking

Hi Zbor - I hope that you are your family are keeping well. Many thanks for taking the time to upload this spreadsheet. Very kind of you. All the best D

This code will show in sheet 1 columns "A to E", the ID Values, and the Corresponding addresses for Sheet "Old" and Sheets "New" where there is not a Match.

Please Login or Register  to view this content.

Regards Mick

For anyone else looking for something similar but VBA based - I found this code online and amended it slightly. It doesnt export modified rows to another sheet but it does highlight them

Please Login or Register  to view this content.

Hi Mick - i've just seen your reply. Thats nice of you. I'll take a look now to be sure I understand it and have a little play.

Thanks for taking the time to help me. Most appreciated.

All the best

Hi Guys - thanks so much for all of your help. You have made my day a lot easier as my boss has stopped busting my B****!!! thanks so much!!