Hyper link to another sheet

[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

 

[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.

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

 

[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")