View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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