Using Hyperlinks

  • Thread starter Thread starter PeterG
  • Start date Start date
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.
 
How about a formula in an adjacent cell?

=HYPERLINK("#'" & A1 & "'!a1")
 
Dave,

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

Peter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink via indirect cell reference 8
Hyperlinking to another worksheet in existing file 3
Hyperlink Help 4
Excel Macro to hyperlink an archived worksheet to an index page 0
Locked worksheet & hyperlinks (w/ select locked cells unchecked) 1
vlookup inside a hyperlink 1
hyperlink to a cell in another spreadsheet with condition 1
Hyperlinks on Protected worksheet 1

Back
Top