Stacking tables using vba

shenry87

New Member
Joined
Aug 29, 2013
Messages
2
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!
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
What is the source data? Using one UNION query on that might be a lot simpler.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Do they all come from the same database?
 

Watch MrExcel Video

Forum statistics

Threads
1,098,992
Messages
5,465,867
Members
406,452
Latest member
GroupGoal

This Week's Hot Topics

Top