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