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.
Compare 2 MS Excel sheets and copy data to a new one