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

truongtran Posts 1 Registration date Thursday November 3, 2016 Status Member Last seen November 3, 2016 - Nov 3, 2016 at 07:12 AM
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.