Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 113
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Linking Excel Tables

Linking Two Excel Tables

Yes, it is possible to link two separate Excel tables so that the data flows between the tables and sorts as if the two were just one table. Here's how you can do it:
  1. Open both Excel tables that you want to link.
  2. Select the cell in the first table where you want to start the link.
  3. Click on the "Formulas" tab in the ribbon.
  4. Click on the "Insert Function" button.
  5. In the "Insert Function" dialog box, type "INDEX" in the search box and click "Go".
  6. Select the "INDEX" function and click "OK".
  7. In the "Function Arguments" dialog box, select the range of cells in the second table that you want to link.
  8. Enter the row number of the first cell in the second table that you want to link.
  9. Enter the column number of the first cell in the second table that you want to link.
  10. Press "Enter" to complete the formula.
  11. Copy the formula to the rest of the cells in the first table where you want to link data from the second table.
  12. Repeat the process in the second table to link data from the first table.

Now, when you add data to one table, it will overflow into the adjoining table and the data will be sorted and arranged properly across all tables. If you sort the data in one table, it will also be sorted in the other table.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 464
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 113
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing / Linking Dynamic Data or ASP Tables into Excel ? Dan Thompson Excel Discussion (Misc queries) 0 November 24th 09 07:19 PM
LINKING TABLES IN EXCEL Hugo Perea Excel Worksheet Functions 1 October 30th 08 12:10 AM
Linking tables and worksheets phil parker29 Excel Worksheet Functions 0 September 1st 07 04:22 PM
Linking Tables between sheets BobD New Users to Excel 2 July 4th 06 03:56 PM
Linking excel pivot tables [email protected] Excel Discussion (Misc queries) 1 February 24th 06 01:28 AM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"