I have 3 tables all in one worksheet that are linked to source data which is refreshed daily. Each table has the same column labels and I would like to stack them into a single table using vba. I currently have 2 problems: I would like to copy from the second row down in each table to the last row with text in (copying a whole table appears to also copy blank rows that are formatted as a table), secondly, I need to the second table to copy at the bottom of the first i.e. the last row with data in. Some code to help me through this would be greatly appreciated. Apologies, my 'enter' button doesn't seem to work!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Stacking tables using vba
- Thread starter shenry87
- Start date
The source data is an SQL Extract of sales order data i.e. production, wholesale, retail etc
Upvote
0
