link to another worksheet in the same work

[jae]

Can I create a hyperlink in one sheet so that when I click on it, it brings
me to a different worksheet in the same work book? I've got a sheet with a
list of names and then a tab that corresponds to each name. I want to be
ablet o click on a name on the first tab and have it bring me to that
person's individual tab. Please help.

 

[Sheeloo]

Choose Insert->Hyperlink

Click on 'in this document', choose the sheet and enter the address

 

[Elle]

One more step for a beginner: choose Insert/Hyperlink (keyboard shortcut is
Ctrl+K), then in the window that appears, on the left under "Link to" click
"Place in This Document." Then you will see your worksheet tab names; choose
the one you want to link to.
Elle

 

[Martin ©¿©¬]

One more step for a beginner: choose Insert/Hyperlink (keyboard shortcut is
Ctrl+K), then in the window that appears, on the left under "Link to" click
"Place in This Document." Then you will see your worksheet tab names; choose
the one you want to link to.
Elle

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

 

[Gord Dibben]

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

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 Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

If you don't want code, then you can get fairly close by right-clicking the
Tab Scrollers and choosing the sheet you want from the pop-up list.

Cheers,
Shane Devenshire

in message