Maintaining a hyperlink to moved data within the work book

K

Kev Nurse

Excel 2000. Cell A1 has a hyperlink to Cell A2. If I cut and paste A2 to,
say, A3, the hyperlink does not change its destination. A1 is still linked
to A2. How can I get the hyperlink to change its destination to the new
location of the cut and pasted data?

It must be possible, surely.....

Regards
Kev Nurse
 
D

Dave Peterson

If you give A2 a nice name (Insert|Name) and use that name in the hyperlink,
does that help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get a hyperlink to track specific data in a worksheet? 1
How do I get a hyperlink to track cut and paste data? 2
Referencing a cell even if its contents are moved moved/replaced 6
CREATING HYPERLINK IN EXCEL 1
Can I fill cells with a hyperlink 2
Loosing correct hyperlnk location after sorting spreadsheet data 2
changing the name of a hyperlink cell when copied 3
Update a hyperlink in excel spreadsheet 5

Top