Hyper link to another sheet

B

Brian Ferris

Hi there,

I have a list of items in the main sheet. For each item
there is a respective sheet named for it. Is it possible
to create a hyperlink whenc licked leading you to that
particular sheet. (I know this can be done through a
command button, but I want this to be done through a
hyperlink).

Thanks for your help,

Brian
 
J

Jan Karel Pieterse

Hi Brian,
I have a list of items in the main sheet. For each item
there is a respective sheet named for it. Is it possible
to create a hyperlink whenc licked leading you to that
particular sheet.
Click to expand...

Use the hyperlink function.

Say cell A1 contains the text
Sheet1

Then this function creates a hyperlink to cell A1 on that sheet:

=HYPERLINK("#" & A1 & "!A1","GoTo this page")

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
D

Dave Peterson

And just in case your worksheet name needs single quotes around it (if it
contains spaces for example):

=HYPERLINK("#'" & A1 & "'!A1","GoTo this page")
 
Top