Index Page

[Manos]

Dear all
i have a quite big workbook with more than 20 small sheets. i woul like to
create a sheets which will work as an index page.
e.g i would like to hit on the name and the user go directly to the rigth
sheet.
There is anyway that i can do this by a formula or i have to use visual
basic?
Thanks in advance
Manos

 

[Ron de Bruin]

Hi Manos

Check out
http://www.mvps.org/dmcritchie/excel/buildtoc.htm


Don't you like the right click on the arrows on the left off the sheet tabs.

Or with a macro

Sub SheetList_CP()
'Chip Pearson, 2002-10-29, misc., %23ByZYZ3fCHA.1308%40tkmsftngp11
'Dave Peterson, same date/thread, 3DBF0BA8.4DAE9DA0%40msn.com
On Error Resume Next
Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute
If Err.Number > 0 Then
Err.Clear
Application.CommandBars("Workbook Tabs").ShowPopup
End If
On Error GoTo 0
End Sub

You can sort your sheets if you want like this
http://www.cpearson.com/excel/sortws.htm