Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 07, 08:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,069
Default Linking cells between sheets

Example: Sheet1 has master data which is linked to various other 'working'
sheets in the same workbook. In practice, the master data has to be moved
around regularly, using cut and paste. Each time this happens, Excel moves
the reference in the 'working' sheet, which is not what is required.
All I want to do (for example) is make sure that cell A8 in the working
sheet ALWAYS equals cell A2 in the master sheet - even if I have cut and
pasted the data in A2 on the master sheet to another location. I have tried
=Data!A2 and =Data!$A$2 to no avail.

Is there any way to 'lock' the referenced cell (Working A8) to the master
cell (A2).

Help much appreciated.

  #2   Report Post  
Old March 12th 07, 12:14 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default Linking cells between sheets

Did you read Gary's Student's reply?
(what an odd name he has; how difficult it is to make possessive!)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John" wrote in message
...
Example: Sheet1 has master data which is linked to various other
'working'
sheets in the same workbook. In practice, the master data has to be moved
around regularly, using cut and paste. Each time this happens, Excel
moves
the reference in the 'working' sheet, which is not what is required.
All I want to do (for example) is make sure that cell A8 in the working
sheet ALWAYS equals cell A2 in the master sheet - even if I have cut and
pasted the data in A2 on the master sheet to another location. I have
tried
=Data!A2 and =Data!$A$2 to no avail.

Is there any way to 'lock' the referenced cell (Working A8) to the master
cell (A2).

Help much appreciated.





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
Linking a name across 30 sheets. pano Excel Worksheet Functions 4 March 23rd 07 07:09 PM
Linking cells between sheets John Excel Worksheet Functions 4 March 13th 07 09:24 PM
Linking cells between sheets John Excel Worksheet Functions 0 March 11th 07 06:51 PM
Linking chart cells between sheets CADMAN Excel Discussion (Misc queries) 0 February 5th 07 09:36 PM
linking sheets Theresa Excel Worksheet Functions 1 November 4th 05 05:28 PM


All times are GMT +1. The time now is 06:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017