Hi all,
I'm hunting for some code which would do a simple compare of data in 2 sheets within the same workbook and then highlight differences in sheet 3 (based on sheet 1 data used as a base).
The macro would copy sheet 1 and paste it in sheet 3 and then compare to sheet 2 with any differences highlighted in yellow.
Data in both sheets have the same format and column headings but the rows would vary.
Column A contains a unique reference number which i thought could be used as the identifier between the 2 sheets.
I've attached a basic test file which may be useful.
Below is some code which compares 2 columns in the same sheet and highlights differences. I was hoping it could possibly be modified/expanded on to apply to above scenario.
Bookmarks