Loop through Sheets to add new data to last row of Table - VBA

**Jlopez21887** · 04-09-2020, 11:55 AM

I am working on a solution to copy data from several Sheets to a single sheet and append it to the last row of an existing table. I have the code working except when the data is copied to the bottom of the srcWs it does not take the form of the current table. I am using UsedRange because there are gaps in the data from the actShtNames that could amount to several blank Rows being copied.

Please Login or Register  to view this content.

**harrisonland** · 04-10-2020, 12:00 PM

Not spent time looking through the code, but you say you have it working except that...

So... does it work if you expand the table first?

Please Login or Register  to view this content.

Tim

**mjr veverka** · 04-10-2020, 01:42 PM

Originally Posted by Jlopez21887

... to copy data from several Sheets to a single sheet and append it to the last row of an existing table ...

Attach an xls example with the actual, real layout of data in sheets (data should not be true to protect privacy and confidentiality) and show in it the expected result of the macro.

Loop through Sheets to add new data to last row of Table - VBA

LinkBack

Thread Tools

Rate This Thread

Display

Loop through Sheets to add new data to last row of Table - VBA

Re: Loop through Sheets to add new data to last row of Table - VBA

Re: Loop through Sheets to add new data to last row of Table - VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop through each sheets in the workbook to find specific cell on my table

[SOLVED] Loop through data validation list and only print sheets that are populated with data

[SOLVED] Auto email loop with formatted table data breaking on second loop VBA

Table that includes data from current sheets and future sheets

Loop to insert data to a series of sheets

Copy Data between sheets with a worksheet loop

[SOLVED] Loop that deletes sheets if data ends on a certain row

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions