View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hyperlink to another sheet, same workbook

You could also use the =hyperlink() worksheet function:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)



Dgwood90 wrote:

I am trying to create hyperlinks to other sheets in the same book. When I
click on the link, I receive File not found. I followed the instructions in
help with no success.


--

Dave Peterson