Compare 2 workbooks

Question

I have 2 workbooks ( version 1 and version 2 ). I need to compare 2 versions and mark the differences in 2 separate columns as "Present in version1 " and " not present in version 2". Column structures are same for both versions

I have tried few vba code where it will only highlight the changes.

Answer 1

Many don't realize this but, depending on which version of Office you have, you may have Spreadsheet Compare already installed on your system.

• Compare two versions of a workbook by using Spreadsheet Compare

• Basic tasks in Spreadsheet Compare

• Overview of Spreadsheet Compare

To find out if you have it, hit your Windows key and type spreadsheet compare.

There are sites that claim to have free downloadable versions - but I can't vouch for their legitimacy.