Linking cells in Excel 2007

  • Thread starter Thread starter JJH281
  • Start date Start date
J

JJH281

I wish to link a cell which updates automatically in one worksheet to show
the same (current value in another worksheet within the same file - I tried
hyperlink but got ~data? Help please
 
Use the formula:

='Sheet Name'!A1

This will "link" to the cell A1 on the worksheet named "Sheet Name".
Substitute your own sheet name and cell reference. Note the single quotes
around the sheet name in the formula, which are only necessary if you have
spaces or special characters in your sheet name.

HTH
Elkar
 
Many thanks for the info! It works!

Elkar said:
Use the formula:

='Sheet Name'!A1

This will "link" to the cell A1 on the worksheet named "Sheet Name".
Substitute your own sheet name and cell reference. Note the single quotes
around the sheet name in the formula, which are only necessary if you have
spaces or special characters in your sheet name.

HTH
Elkar
Click to expand...
 
I have done this but the content in the cells within the same column keep
changing!!
Help
 
Back
Top