Hi everyone - heres a little puzzle thats beyond my capabilities.
I want to compare two excel documents, I could possibly move the sheets I want to compare into the same workbook.
Basically, I need to be able to see what changes have occured between the two sheets, firstly for new entries (new records/rows) OR modifications (alterations within a record/row). Each record (row) has the following 9 criteria (coloumns) along it, these are: Reference Number, Title, First Name, Surname, Age, Description, Start Date, End Date and Duration. Each Record/Row (is a client and) is assigned a Unique Reference Number.
I am after a macro or VBScript code to compare the sheets and then generate a seperate list displaying these NEW and MODIFIED records.
For example: Only showing or listing those records (rows) that are:
NEW entries - eg. A record (row) that appears only on sheet 2 (new sheet) and NOT sheet 1 (old/original sheet).
MODIFIED entries - eg. A record (row) that has altered one of its other criteria (not included reference number) like description, where on sheet 1 (old/original sheet) the description was 'dog', but on sheet 2 (new sheet) it is now 'cat'.
Any advice or ideas on this would be much appreciated.
Regards,
PC
Bookmarks