Macro to Compare two sets of Data

Hi All,

I've had some fantastic help from members of this forum so I thought I'd post my latest problem!

Trying to keep it simple so here goes!:

My Workbook has two sheets; 1 called "Audit Before Restore" and 2 called "Audit After Restore"
For quick background and to understand the issue my Sage Accounting software failed so I generated these two sheets before the fix and after the fix (i.e. the Restore). The data in each sheet should be identical, but it is not.
I want to create a macro or some other automated feature to contrast the two reports. The BEFORE sheet contains all the data, but the AFTER sheet is missing entries.
To make it a bit trickier when SAGE was reloaded and the AFTER sheet created I can see that some entries correctly appear in both sheets, however SAGE generated different No References(Column B), so my thought was that the cross check would need to be the Gross Value (Column A) with perhaps a double check against another cell say for example the Net entries.

I thought the logic would be the BEFORE sheet checks each row or some key cell in the AFTER sheet and marks as red all those entries in the BEFORE sheet that do not appear in the AFTER one.

I've attached the workbook to help you!

Thanks so much in advance.

Ian





AUDIts BEFORE and AFTER.xls