VBA / Power Query to copy sheet 1 data to sheet 2 below the last used row

[mukuljain99]

Hello all,

I want to copy data from sheet 1 to sheet 2 below the last used cell/row.

Attaching excel file for better understanding, I want the highlighted cells to go to sheet2 with M or VBA code. or if any other easy alternatives available.

[Olly]

Using VBA

Please Login or Register  to view this content.

Using Power Query (M)

Format data in Sheet1 as a table (TableNew).
Format Data in Sheet2 as a table (TableTemp)

Create query:

Please Login or Register  to view this content.

Name the query TableCurrent, and Load To Table on Sheet2.

Delete TableTemp, and amend query to:

Please Login or Register  to view this content.

Now whenever you refresh data, whatever is in the table on Sheet1 will be appended to the table on Sheet2.