If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Excel Tables
Is there any way to link two separate Excel tables so that the data flows
between the tables and sorts as if the two were just one table? We have worksheets where the quantity of data forces us to place the data in multiple tables, for example in three tables across a landscape page. However, we want the data in the three tables to behave as a single table, much like linked text frames in a page layout program. When adding data we simply want the overflow to be pushed into the adjoining table. Likewise, when we sort the data we want the data to be sorted in all three tables and redisplayed properly sorted and arranged across the tables. Is this possible? Thank you for any help with this issue. |
#2
|
|||
|
|||
Linking Excel Tables
=Sheet1!A1 dragged down an across, or Group the Sheets and what you type in
1 Worksheet will also show on the others in the Group. I.e Hold down your Ctrl key and select the sheet tabs of those you wish to group. Don't forget to ungroup -- Regards Dave Hawley www.ozgrid.com "Blue Max" wrote in message ... Is there any way to link two separate Excel tables so that the data flows between the tables and sorts as if the two were just one table? We have worksheets where the quantity of data forces us to place the data in multiple tables, for example in three tables across a landscape page. However, we want the data in the three tables to behave as a single table, much like linked text frames in a page layout program. When adding data we simply want the overflow to be pushed into the adjoining table. Likewise, when we sort the data we want the data to be sorted in all three tables and redisplayed properly sorted and arranged across the tables. Is this possible? Thank you for any help with this issue. |
#3
|
|||
|
|||
Linking Excel Tables
Thanks for the reply, Dave. However, I still don't understand as follows:
FIRST, grouping tabs only assures that changes on one worksheet are reflected on the other sheets. That is not particularly what we want since, one, we are not using multiple sheets and, two, we are not simply looking for a copy of the table, but how to link tables so the multiple tables act as a single contiguous table. SECOND, dragging down and across simply selects a contiguous range. Are you inferring, however, that the range can be broken into three separate segments (or tables) that will allow data to flow across segments (or tables) as if it were a single table? If so, this may represents a solution for us. THIRD, to summarize our need, we need data to flow between three side-by-side tables, on the same worksheet, as if it were a single table. Thanks, Richard ********************* "ozgrid.com" wrote in message ... =Sheet1!A1 dragged down an across, or Group the Sheets and what you type in 1 Worksheet will also show on the others in the Group. I.e Hold down your Ctrl key and select the sheet tabs of those you wish to group. Don't forget to ungroup -- Regards Dave Hawley www.ozgrid.com "Blue Max" wrote in message ... Is there any way to link two separate Excel tables so that the data flows between the tables and sorts as if the two were just one table? We have worksheets where the quantity of data forces us to place the data in multiple tables, for example in three tables across a landscape page. However, we want the data in the three tables to behave as a single table, much like linked text frames in a page layout program. When adding data we simply want the overflow to be pushed into the adjoining table. Likewise, when we sort the data we want the data to be sorted in all three tables and redisplayed properly sorted and arranged across the tables. Is this possible? Thank you for any help with this issue. |
Thread Tools | |
Display Modes | |
|
|