Copy New Data Only ??

[PNGBill]

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]

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