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

How about a formula in an adjacent cell?

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


PeterG wrote:

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

--

Dave Peterson

Dave,

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

Peter.


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

Dave,

Sorted. I found the bits that I needed.

many thanks.


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