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
 
Top