Relative and absolute hyperlinks
I have a cell in a worksheet that is hyperlinked to another cell in that same
worksheet. (Let's say that A1 is hyperlinked to F7). If I move the text that is in F7 to another row and column, how can I get the A1 hyperlink reference to move to the new location. (Let's say that the text in F7 is now in cell G12. A1 still is hyperlinked to F7 and I want it to change to G12 when I move the text in F7 to G12.) It sounds like it should be simple, but I couldn't turn up anything that seemed to answer my question. I hope someone can help. This has been a constant problem with me in Excel worksheets and workbooks. |
Relative and absolute hyperlinks
One way:
Name the target cell. Then in the hyperlink dialog, Document/Locate, choose your named range in the input bax. In article , Musette wrote: I have a cell in a worksheet that is hyperlinked to another cell in that same worksheet. (Let's say that A1 is hyperlinked to F7). If I move the text that is in F7 to another row and column, how can I get the A1 hyperlink reference to move to the new location. (Let's say that the text in F7 is now in cell G12. A1 still is hyperlinked to F7 and I want it to change to G12 when I move the text in F7 to G12.) It sounds like it should be simple, but I couldn't turn up anything that seemed to answer my question. I hope someone can help. This has been a constant problem with me in Excel worksheets and workbooks. |
Relative and absolute hyperlinks
THANKYOUTHANKYOUTHANKYOU!! And, thank you for keeping it simple! It worked! "JE McGimpsey" wrote: One way: Name the target cell. Then in the hyperlink dialog, Document/Locate, choose your named range in the input bax. In article , Musette wrote: I have a cell in a worksheet that is hyperlinked to another cell in that same worksheet. (Let's say that A1 is hyperlinked to F7). If I move the text that is in F7 to another row and column, how can I get the A1 hyperlink reference to move to the new location. (Let's say that the text in F7 is now in cell G12. A1 still is hyperlinked to F7 and I want it to change to G12 when I move the text in F7 to G12.) It sounds like it should be simple, but I couldn't turn up anything that seemed to answer my question. I hope someone can help. This has been a constant problem with me in Excel worksheets and workbooks. |
All times are GMT +1. The time now is 09:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com