Support Portal

for ProcessRobot and WinAutomation

Start a new topic

How to compare 2 worksheets of an Excel file

ADMIN

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

xlsx
waj
Login or Signup to post a comment