VBA to insert copied data into Table nextrow available.

[sintek]

Hi All

I have below code that copies from a Table to a New table and then deletes. problem is every time the code runs, the data in new table is overwritten. I need it to be added to next row available in Table and move down. How can I tweak the code to allow for my needs.

Please Login or Register  to view this content.

[kasan]

Probably with

Please Login or Register  to view this content.

[kasan]

duplicate message

[sintek]

Hi Kasan

Thanks for reply. i tried that previously and got a "Runtime error 1004, Application defined or Object defined error"

[sintek]

Both are Tables

Sheets("Customer Listing") is Table2
Sheets("Lost Customers") is Table 3

[sintek]

Hi All

Not to worry, i solved my problem as follows:

Please Login or Register  to view this content.

[IonutC]

Hi,

If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .