How to compare two excel sheets with varying data - need diff [Closed]

Report
-
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#

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!