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

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

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