crosslink here:Comparing data on 2 sheets (varying rows) and highlight differences in 3rd
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 highlight any differences to sheet 2 in yellow.
Data in both sheets have the same format and column headings but the rows would vary which adds an element of difficulty.
Column A contains a unique reference number which i thought could be used as the identifier between the 2 sheets.
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 highlight any differences to sheet 2 in yellow.
Data in both sheets have the same format and column headings but the rows would vary which adds an element of difficulty.
Column A contains a unique reference number which i thought could be used as the identifier between the 2 sheets.