How to compare 2 worksheets of an Excel file
This Process uses SQL and VBscript to highlight rows in the first Worksheet of the Excel file (must have at least 2 Worksheets) that have one matching and one mismatching column between the first two Worksheets based on the choice of the user.
It can be modified to
-use data from more Worksheets
-use more columns as matches or mismatches using the logical operators (AND, OR)
-highlight the results in other Worksheets.
Example usage with the attached excel file:
-Select the 2 'User' Columns as matching columns
-Select the 2 'Expense $' Columns as mismatching columns
Result: highlight in the first Worksheet the 3 User-rows that have different Expenses in each Worksheet-month