Can I click on a cell on one worksheet and make it take me to another worksheet

  • Thread starter Thread starter steve12345
  • Start date Start date
S

steve12345

Hello
Thanks for looking at this:
I want to list a number of names on sheet one of a workbook and I want
to be able to click on a name and it take me to another worksheet, in
the same workbook which is linked to that name.
Can I do it?
All help is much appreciated
Thanks
Steve
 
Go to Insert>Hyperlink, click "Place In This Document", choose where
you want to jump and click OK. A link is created; when you click on
it, the selection is changed to wherever you specified.


HTH,
JP
 
Sounds like you are creating an Index Sheet.

You can do it by making each name a hyperlink to the appropriate sheet.

My question is............how do you propose to get back to that original sheet
so's you can pick another name from the list?

If you right-click on the navigation arrows at bottom left you will get a list
of 15 sheets and "more sheets".

Selecting one of those will jump you to that sheet.


Gord Dibben MS Excel MVP
 
Gord Dibben,
Wouldn't you place a hyperlink on each sheet, back to the Index Sheet?

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Sounds like you are creating an Index Sheet.

You can do it by making each name a hyperlink to the appropriate sheet.

My question is............how do you propose to get back to that original
sheet
so's you can pick another name from the list?

If you right-click on the navigation arrows at bottom left you will get a
list
of 15 sheets and "more sheets".

Selecting one of those will jump you to that sheet.


Gord Dibben MS Excel MVP
 
Yes, you could do that but to my way of thinking why go those extra steps to
make a hyperlink on each sheet to go back to Index sheet to pick another sheet.

You can use the right-click on the navigation arrows or build a Navigation
Toolbar as per Dave's code on Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob Phillips.

http://tinyurl.com/yoa3dw


Gord
 
Gord,
I did not see those references on how to build a navigation toolbar, in your
previous posting. And it would be something like I would do since I'm a
novice with Excel.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Yes, you could do that but to my way of thinking why go those extra steps to
make a hyperlink on each sheet to go back to Index sheet to pick another
sheet.

You can use the right-click on the navigation arrows or build a Navigation
Toolbar as per Dave's code on Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord
 
They link was not posted in my first reply, but was certainly posted in my
second reply.

See below.


Gord
 
Back
Top