Dynamic Hyperlinks

[PJFry]

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

 

[Gary''s Student]

With a tabname in A1, try:

=HYPERLINK("#'" & A1 & "'!A1","place to go")

 

[PJFry]

Perfect! The # is what I was missing from my earlier attempts.