sorting sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Twilley - 28 Jun 2007 22:08 GMT

I have a list of numbers that coincide with the sheet numbers... i want to be
able to click on the number on my first sheet and have it open up the sheet#
that i click on... is this possible and if so what function do i use to
direct it to do this??

Reply to this Message

George Gee - 28 Jun 2007 22:18 GMT

Right-click the cell containing the number of the tab you wish to go to
(open).
Choose 'Hyperlink' from the menu.
In the dialog box click 'Place in this document' on the left.
Select the sheet from the list.

George Gee

>I have a list of numbers that coincide with the sheet numbers... i want to
>be
> able to click on the number on my first sheet and have it open up the
> sheet#
> that i click on... is this possible and if so what function do i use to
> direct it to do this??

Reply to this Message

Gord Dibben - 28 Jun 2007 23:06 GMT

You can use hyperlink>place in this document on your list in sheet1 to jump to
the other sheets.

Question...........how will you get back to sheet1 with the list of numbers to
go to other sheets?

You may just need some code you assign to a button which is accessible from any
sheet.

Did you know that if you right-click on the navigation arrows at bottom left
side of sheet tabs you get a list of 15 sheets and "more sheets"?

Gord Dibben MS Excel MVP

>I have a list of numbers that coincide with the sheet numbers... i want to be
>able to click on the number on my first sheet and have it open up the sheet#
>that i click on... is this possible and if so what function do i use to
>direct it to do this??

Reply to this Message