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