View Single Post
  #1   Report Post  
PeterG
 
Posts: n/a
Default Using Hyperlinks


Hi again,

Another spreadsheet I have, has 3 drawings in it on 3 different
worksheets.
From the main worksheet, how can I setup hyperlinks to allow the user
to jump to that particular worksheet depending on the value contained
in a single cell.

For instance.

If cell A1 contains the value DRG1 - then the hyperlink should take
them to the worksheet named DRG1, if the cell contains DRG2, then
worksheet named DRG2 and so on...

Thanks.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=380051