Linking cells between sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try =INDEX(Data!$1:$65536,2,1)
or =INDIRECT("Data!A2")

The first one has the advantage that it is nonvolatile and will still
work if the data sheet is renamed.
 
=INDIRECT("Data!" & "A" & "2")


will always pickup cell A2 on sheet Date, no matter what row/columns have
been inserted/deleted.
 
Very good. Thanks very much.

Gary''s Student said:
=INDIRECT("Data!" & "A" & "2")


will always pickup cell A2 on sheet Date, no matter what row/columns have
been inserted/deleted.
Click to expand...
 
Back
Top