How do I get a hyperlink to track data movement?

[Kev Nurse]

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

[theDude]

Kev Nurse,

If you name the cell A1 on Sheet2 (select the cell, then use menu Insert -> Name->Create...), then define your hyperlink to the Name, it will follow that named range if you cut and paste it to a different location.

Hope this helps,
theDude