I have Excel 2000. I have hyperlinked Sheet1 A1 to Sheet2 A1.
How do I get the hyperlink in Sheet1 A1 to maintain its link with the data
if I cut the data from
Sheet2 A1 and paste it to any other cell on Sheet2?

Any guidance would be much appreciated, thanks.

Regards
Kev Nurse

This was the answer you got to your Jan 31 post:


Name that range (Insert|name|define)

Then use that name in your hyperlink:

I created a name of myCell and used this formula:

=HYPERLINK(myCell,"click me")


Didn't it work for you?

Kev Nurse wrote:

I have Excel 2000. I have hyperlinked Sheet1 A1 to Sheet2 A1.
How do I get the hyperlink in Sheet1 A1 to maintain its link with the data
if I cut the data from
Sheet2 A1 and paste it to any other cell on Sheet2?

Any guidance would be much appreciated, thanks.

Regards
Kev Nurse

--

Dave Peterson