Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking worksheet data
I have a worksheet (orders) which lists orders by County.
I would like to link the data in Orders (cells A2 to T7) to County 1 worksheet. I would like to link the data in Orders (cells A8 to T15) to County 2 worksheet. When the data in Orders is updated, I would like the data in County 1 and County 2 to be updated also. I know it can be done, but I can't figure out how to do it. -- Glenn Glenn T. Dulmage 207 Valley Road Chestertown, MD 21620 410-778-5166 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking worksheet data
There are usually better ways of working than making linked copies of
the data - e.g. filtering a table, or creating a pivot table with County as a page field, making the master data be in the County sheets and using Data Consolidate to build the combined sheet.... However, if these don't suit your needs and current data arrangement, and if the area used for each County on the combined sheet is fixed: Select the area for County1; Edit Copy; Select the cell on the County1 sheet where you want the linked data to start; Edit Paste Special Paste Link Repeat for each county. If the area for each county is not fixed (e.g. you might add or delete a row in the County1 area) then I would advise against using linked data. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking worksheet data | Excel Worksheet Functions | |||
can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
Linking rows of data to another worksheet | Excel Discussion (Misc queries) | |||
Linking to Pivot data in another worksheet | Excel Discussion (Misc queries) | |||
Linking multiple data into one worksheet. | Excel Worksheet Functions |