Copy and Paste from one sheet to next empty table row in another sheet

I am trying to merge two sheets together, where I need to copy all the content from Sheet1, minus the header row, into the next empty row of Sheet2. Sheet2 data is in a table format so when I paste from Sheet1, it isn't adding to the table. Is there a way to fix this?

Also, if the data in Sheet1 can vary, is there a more effective way to copy the data?

Please Login or Register  to view this content.

Hello
I've created a test file with a 3 column table (Table1) and used the following code to copy from Sheet1 with no problems.

Please Login or Register  to view this content.

I've referenced the Table1 directly and used its rows count to find the last row.

Also, if the data in Sheet1 can vary...

I think you would need to elaborate on what you mean by 'vary'.

DBY

Originally Posted by Winon

Hello shre0047,



We could employ an InputBox to handle this, however there might be some complications, depending on which Column to use to find the last empty row in your Table.

I guess we have to start somewhere, so please try the Code below in a Standard Module.

Please Login or Register  to view this content.

Feel free to change the attached sample Workbook to your preferences.

Regards.

What i mean regarding the data varying is the number of rows. Sometimes, it could be 100, other times it could be 2000. The columns would stay the exact same though.