A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking worksheet data



 
 
Thread Tools Display Modes
  #1  
Old August 8th, 2008, 09:14 PM posted to microsoft.public.excel.links
Glenn Dulmage
external usenet poster
 
Posts: 12
Default 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  
Old August 11th, 2008, 08:36 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.