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

[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

 

[JP]

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

 

[Gord Dibben]

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

 

[Rich/rerat]

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

 

[Gord Dibben]

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

 

[Rich/rerat]

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

 

[Gord Dibben]

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

See below.


Gord