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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,114,520
Messages
5,548,528
Members
410,845
Latest member
OldSwimmer1650
Top