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

Report

Sue - Feb 14, 2017 at 01:49 PM

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#

How to compare two excel sheets with varying data - need diff
How to compare two Excel sheets with varying data ✓ - Forum - Excel
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Comparing Two Excel Sheets and copying like data to third sheet ✓ - Forum - Excel
Macro to compare two excel sheets and highlight the difference ✓ - Forum - Excel
How to Compare Two Excel Sheets and Combine Unique Data - How-To - Excel

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

Your reply

Subscribe To Our Newsletter!