Hello,
I am looking for a solution for below scenario.
I have 2 sheets with same columns. Every week the data (rows) gets updated , deleted or added in each sheet.
I want a seperate sheet which shows the difference of between sheet 1 and sheet 2
Difference sheet should display missing values and different values
I'll include an example below.
Sheet 1 - Prod
TBL_NM | TBL_TYP | SCHEMA_TYPE | TBL_PRFX | CRT_NM | REMARKS_TX
ABC xyz A2 EAA UNICODE IT#234#
Sheet 2 - QA
TBL_NM | TBL_TYP | SCHEMA_TYPE | TBL_PRFX | CRT_NM | REMARKS_TX
ABC xyz A2 EAA UNICODE IT#234#