hyperlink based on user's input
 

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


--
izbryte


------------------------------------------------------------------------
izbryte's Profile: http://www.excelforum.com/member.php...o&userid=16740
View this thread: http://www.excelforum.com/showthread...hreadid=320103

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

--
Regards
Frank Kabel
Frankfurt, Germany

"izbryte" schrieb im Newsbeitrag
...

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


--
izbryte


---------------------------------------------------------------------
---
izbryte's Profile:
http://www.excelforum.com/member.php...o&userid=16740
View this thread:
http://www.excelforum.com/showthread...hreadid=320103