| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How make hyperlink refer to cell content rather than cell address.
Either name that range (a75) (insert|name|define) and point at that name or use
a worksheet formula: =HYPERLINK("#"&CELL("address",A75),"Click me") Omunene wrote: An Excel spreadsheet with names in Column A. "Bush, George" is in cell A75. "Dubya" is in cell A125. I want a hyperlink from "Dubya" to "Bush, George." If I add or delete rows above "Bush, George," I want the hyperlink to follow the name, not just keep pointing to call A75. Help? (Thanks!) -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
