| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Hyperlinks
Is it possible to creat a dynamic hyperlink to an different worksheet? I
want to be able to set the hyperlink to the value of a cell. eg. If cell A1 = LKP-1000i-Bulk then I want the hyperlink to take the user the tab named LKP-1000i-Bulk. When I update the report next month, LKP-1932xp could be in cell A1. Now I want the hyperlink to take me to that tab. Is this possible? Thanks! PJ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic Hyperlinks
With a tabname in A1, try:
=HYPERLINK("#'" & A1 & "'!A1","place to go") -- Gary''s Student - gsnu200821 "PJFry" wrote: Is it possible to creat a dynamic hyperlink to an different worksheet? I want to be able to set the hyperlink to the value of a cell. eg. If cell A1 = LKP-1000i-Bulk then I want the hyperlink to take the user the tab named LKP-1000i-Bulk. When I update the report next month, LKP-1932xp could be in cell A1. Now I want the hyperlink to take me to that tab. Is this possible? Thanks! PJ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic Hyperlinks
Perfect! The # is what I was missing from my earlier attempts.
"Gary''s Student" wrote: With a tabname in A1, try: =HYPERLINK("#'" & A1 & "'!A1","place to go") -- Gary''s Student - gsnu200821 "PJFry" wrote: Is it possible to creat a dynamic hyperlink to an different worksheet? I want to be able to set the hyperlink to the value of a cell. eg. If cell A1 = LKP-1000i-Bulk then I want the hyperlink to take the user the tab named LKP-1000i-Bulk. When I update the report next month, LKP-1932xp could be in cell A1. Now I want the hyperlink to take me to that tab. Is this possible? Thanks! PJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
| Dynamic hyperlinks | Excel Discussion (Misc queries) | |||
| Dynamic Hyperlinks - Changing Folders and Filename | Excel Worksheet Functions | |||
| Dynamic hyperlinks problem | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Linear Mode
