Macro to compare Col C from two sheets and paste the row in Result Sheet if not matching

[rehana402003]

Hello All,

I am using Excel 2013 and have the following problem as shown in the attached sample

There are 3 Sheets – viz Statement 1, Statement 2 and Result

Statement 1 – has 3 columns
Col A – Date
Col B – Doc No
Col C – Total

Statement 2 – has 3 columns
Col A – Date
Col B – Doc No
Col C – Total

I want a macro which should compare Statement 1 Sheet Column C (Total) with Statement 2 Sheet Col C (Total). If there is a match then ignore that row.
If it is not matching then the entire row from Statement 1 Sheet should be copied on result sheet with the Headings in Row 1

I have shown few outputs on the Result sheet and colored them for explanation purpose only

Thanks in advance

Rehana

[AliGW]

Please update your user profile to show the correct version of Excel.

Do you have the PowerQuery add-in?

[jindon]

Just compare ColC with ColC?

Please Login or Register  to view this content.

[AliGW]

See if the attached PQ solution does what you want. If so, I can talk you through how to load the two source data tables and then merge them to provide the answer.

[rehana402003]

Thanks for all your help as always
Regards

[rehana402003]

Thanks for your solution
I have the code which works for me
But it would be good to know the steps of your solution too
Regards