Change horizontal tables to vertical stacked tables?

[Ed from AZ]

I have four sets of identical "data tables", five columns to a table.
So Table 1 uses columns A-E, Table 2 F-J, and so forth. I update
these tables daily, and not all tables get new data. They are laid
out horizontally because the row counts are not the same for each
table - Table one may have 60 rows, but Table 2 may have 100 rows, and
so forth.

One of my supervisors would like to see these tables as a vertical
stack - Table 1, 2, 3, and 4 all down columns A-E. Since the row
count varies for each table and can vary daily, I'm wondering what the
best way is to accompish this. I could simply write a macro that on
Workbook_Close would get the ranges and stack all of these tables on a
different worksheet, but I'd like to stay away from macros in this
workbook if there's another way.

Can something be done with named ranges or formulas that will give me
the display I need?

Ed

 

[Jim Cone]

Ed,
Copy the sheet (hold down the Ctrl key and drag the sheet tab to the right).
Select each table and drag it where you want.
Only takes a few seconds.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Ed from AZ"
wrote in message
I have four sets of identical "data tables", five columns to a table.
So Table 1 uses columns A-E, Table 2 F-J, and so forth. I update
these tables daily, and not all tables get new data. They are laid
out horizontally because the row counts are not the same for each
table - Table one may have 60 rows, but Table 2 may have 100 rows, and
so forth.

One of my supervisors would like to see these tables as a vertical
stack - Table 1, 2, 3, and 4 all down columns A-E. Since the row
count varies for each table and can vary daily, I'm wondering what the
best way is to accompish this. I could simply write a macro that on
Workbook_Close would get the ranges and stack all of these tables on a
different worksheet, but I'd like to stay away from macros in this
workbook if there's another way.

Can something be done with named ranges or formulas that will give me
the display I need?

Ed