Copy New Data Only ?? (1 Viewer)

PNGBill

Win10 Office Pro 2016
Local time
Today, 15:17
Joined
Jul 15, 2008
Messages
2,271
Hi Forum,
Is it possible to Copy Rows from Workbook A to Workbook B where they do not already exist in Workbook B ?

Workbook A is populated by MYSQL from a Database and overwrites data.
Workbook B has 5 Columns from Workbook A.

It would be great if the code to Copy from Workbook A to Workbook B only copied Rows not already in Workbook B.

This is not a task we do every day so speed is not a priority.

Appreciate any advice on this :)
 

Gasman

Enthusiastic Amateur
Local time
Today, 02:17
Joined
Sep 21, 2011
Messages
14,048
I do this by using a VLOOKUP in a column against the target workbook, and then copy everything with #N/A in that column.?

HTH
 

Users who are viewing this thread

Top Bottom