Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to link to text, not just a cell
Hello!
I am new to this and am quite cornfused. I am trying to set-up a hyperlink from one tab within an excel doc to another tab within the same doc. But when I set the hyperlink to go to a particular cell..and that other tab is altered, then the link is no longer valid. Within each row I do have some unique identifiers that I could use..so I was hoping to link to those (and not the cell it is in). Sorry if I am unclear in explaining my issue. Thanks a great deal for any assitance given! Have a nice day! :o) -- Ben |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to link to text, not just a cell
Maybe you can name the range (Insert|Name) and use that name in the hyperlink.
Or you could use the worksheet function: =hyperlink(). Since it's a formula, it'll adjust to the changes you make to the other sheet. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Ben wrote: Hello! I am new to this and am quite cornfused. I am trying to set-up a hyperlink from one tab within an excel doc to another tab within the same doc. But when I set the hyperlink to go to a particular cell..and that other tab is altered, then the link is no longer valid. Within each row I do have some unique identifiers that I could use..so I was hoping to link to those (and not the cell it is in). Sorry if I am unclear in explaining my issue. Thanks a great deal for any assitance given! Have a nice day! :o) -- Ben -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink in cell that already contains text? | Excel Discussion (Misc queries) | |||
How can I fix HYPERLINK(B2,E2) to the resulting text and link? | Excel Discussion (Misc queries) | |||
How can you mix text and a hyperlink in the same cell? | Excel Discussion (Misc queries) | |||
hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions |