To only copy new data from one wb to another wb

jxj_00

New Member
Joined
Oct 1, 2020
Messages
23
Office Version
  1. 365
Platform
  1. Windows
Hi, I need a code that does the following:

There will be 2 workbooks: WB1, WB2
1. Copy from WB 1 & WB2 but it needs to do 2 things
a. Copy from WB 1, Column 2 to WB2 Column 1 & WB1, Column 3 to WB2, Column 2 & WB1, Column 6 to WB2, Column 3 & WB1, Column 11 to WB2, Column 4 (Copy
starting from WB1, Row 4 to WB2, first empty row (The data starts from row 2)
b. Copy only non-existing data in WB2 (Unique identifier/key is in WB1, Column 2 or WB2, Column 1)

One of the ideas I have is using intersection but I am unsure how to proceed? I am also open to any other solutions.

Thank you in advance!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,113,936
Messages
5,545,105
Members
410,656
Latest member
Hydraulics
Top