You can't, it's not Sheet2!A1 that you move it's the contents. You might want
to look at the hyperlink function instead
Regards,
Peo Sjoblom
"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
|