Excel VBA to move data from a table in one sheet to a table in another sheet on a new row

I have an Excel workbook with two worksheets which both have identical tables. Sheet1 will has a table which will hold current data that is refreshed each week with Sheet2 having a table which will hold data for previous weeks having been moved there.

I am looking for VBA to move the data from the table in sheet1 to the next available row on the table in sheet2 and then delete the moved data from sheet1.I could copy and paste each week but was hoping to automate the process with VBA, unfortunately I am very new to VBA and stuck on this!

The first sheet is titled "Sheet1" with the table named "Table1". The second sheet is "Sheet2" with the table named "Table2".

Any help would be greatly appreciated

Hello DJ,

See if this helps:

Please Login or Register  to view this content.

Please test it in a copy of your workbook.

Cheerio,
vcoolio.