LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks and sorting data Rena Excel Discussion (Misc queries) 0 June 3rd 05 07:50 PM
Addressing hyperlinks in excel Owen Dodd Excel Discussion (Misc queries) 1 April 20th 05 08:35 PM
Problems with hyperlinks Lynde Excel Discussion (Misc queries) 5 January 14th 05 08:39 PM
Can 2 different hyperlinks be in the same Excel cell? rynes01 Excel Worksheet Functions 2 December 7th 04 05:15 PM
up-date hyperlinks in Excel PM Excel Worksheet Functions 0 November 11th 04 11:55 AM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"