| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to cell within a sheet breaks when cells are sorted
How can I lock down (or make relative) a hyperlink? I'm adding hyperlinks
between Sheet 1 (Schedule) & Sheet 2 (2009 Projects); when I sort Sheet 2, the hyperlink on Sheet 1 is no longer valid. For example, the text originally contained in my hyperlink to '2009 Projects'!$A7 has now moved to A10 as a result of being sorted. How can I make the hyperlink stay in sync with the correct text/cell? I've tried pasting as link, tried placing the $ in various places, to no avail. Appreciate any suggestions! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink to cell within a sheet breaks when cells are sorted
=HYPERLINK("#"&CELL("address",'2009 Projects'!A7),"Click me")
If this post helps click Yes --------------- Jacob Skaria "CJ55" wrote: How can I lock down (or make relative) a hyperlink? I'm adding hyperlinks between Sheet 1 (Schedule) & Sheet 2 (2009 Projects); when I sort Sheet 2, the hyperlink on Sheet 1 is no longer valid. For example, the text originally contained in my hyperlink to '2009 Projects'!$A7 has now moved to A10 as a result of being sorted. How can I make the hyperlink stay in sync with the correct text/cell? I've tried pasting as link, tried placing the $ in various places, to no avail. Appreciate any suggestions! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Hyperlink to cell in different sheet | Excel Discussion (Misc queries) | |||
| Use a hyperlink to display a selection of cells on another sheet (in same workbook) | Excel Discussion (Misc queries) | |||
| Creating a hyperlink to a cell on a different sheet | Excel Worksheet Functions | |||
| Hyperlink in cell with line breaks | Excel Discussion (Misc queries) | |||
| Trying to have data from one sheet to another sorted.... | Excel Discussion (Misc queries) | |||
Hybrid Mode
