VBA to Copy New Rows from one Table to another Table

Hi All


I have a spreadsheet that contains 2 tables of data. The rows of each table have a unique id reference in the first column. Table 2 is connected to an external data source. After Table 2 has been refreshed i would like to copy any rows in Table 2 that do not exist in Table 1 to the end of Table 1. A row is determined not to exist in Table 1 if the ID value in Table 2 does not exist in Table 1.

I have attached a sample spreadsheet and tables


Using Excel 2010



Any help or advise appreciated

Here's what I came up with:

Please Login or Register  to view this content.

WBD

Hi,

Here's one macro

Please Login or Register  to view this content.

Just be aware, maybe for other applications, that with large ranges using a loop can be time consuming as the code has to jump back and forth between the Excel app and VBA

It's generally better to filter stuff and do stuff with the filtered range since that only needs one interaction with Excel.

Just for fun, I wondered what it could look like in Office 365:

Please Login or Register  to view this content.

:D

WBD