Using Hyperlinks

P

PeterG

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.
 
P

PeterG

Dave,

Thats the ticket, can I change what is displayed in the cell to rea
"Click Here"
currently it shows #DRG2!b25

Peter
 
Top