LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 143
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
Dynamic hyperlinks Ray Excel Discussion (Misc queries) 0 August 21st 07 06:03 PM
Dynamic Hyperlinks - Changing Folders and Filename Philip J Smith Excel Worksheet Functions 0 April 18th 07 12:24 PM
Dynamic hyperlinks problem Mr.Plankton Excel Worksheet Functions 0 June 21st 06 03:20 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"