Compare 2 MS Excel sheets and copy data to a new one [Closed]

Report
Posts
1
Registration date
Thursday November 3, 2016
Status
Member
Last seen
November 3, 2016
-
Hi all,
I would like to know what to do for the situation below

- I have 2 sheets named as "Current" & "New" and they both have the same columns as these:
(A) Flag - (B) Design Pack No - (C) Customer Order No - (D) SOT - (E) CRD - (F) RTCD - (G) DAP
- Sheet "Current" has existing data that have been updated where sheet "New" includes raw data (untouched data) from sheet Current and new data.

What I want to do now is to compare data from sheet "New" against sheet "Current" based on value in Column B, "Design Pack No". If the value in column B doesn't exist in Sheet Current then the whole row is copied into the 3rd sheet.

Any help will be much appreciated. Thanks so much in advance.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!