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.