Linking cells in Excel 2007
 

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

Linking cells in Excel 2007
 

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


"JJH281" wrote:

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

Linking cells in Excel 2007
 

Many thanks for the info! It works!

"Elkar" wrote:

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


"JJH281" wrote:

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

Linking cells in Excel 2007
 

I have done this but the content in the cells within the same column keep
changing!!
Help


"Elkar" wrote:

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


"JJH281" wrote:

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

Linking cells in Excel 2007
 

See your other post for one suggestion.


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 11:52:06 -0800, 5T4fr33d0m
wrote:

I have done this but the content in the cells within the same column keep
changing!!
Help


"Elkar" wrote:

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


"JJH281" wrote:

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