hyperlink based on user's input

I

izbryte

I have a workbook with several worksheets. Is it possible to jump
(hyperlink) to a specific worksheet by entering its name in a cell?
 
F

Frank Kabel

Hi
you could use the HYPERLINK function referencing this cell. e.g. try
=IF(A1<>"",HYPERLINK("#'" & A1 & "'!A1"),"")

and insert the sheet name in A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to open new window within document 0
Word hyperlinks not working 2
Hyperlinks in OneNote 1
Can UDF return a customized hyperlink? 3
2002 Hyperlink issues 2
Hyperlink to named range in workbook 1
Unable to create/use hyperlinks 4
Hyperlinks stopped working 4

Top