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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Paste Values in linked Cells Only 4
trying to create a link to a link in Excel (2007) 3
How do I keep a hyperlink valid if the link to cell is moved? 1
Moving hyperlinks from 2003 to 2007 1
Cells act as if they are linked-link does not display in entry bar 1
Linking cell format across worksheets 3
Formula Linking Issue 1

Back
Top