Create Index

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Hi all,

I have a workbook with quite a lot of sheets and diagrams inside
i would like to create a sheet which will work as an index page for the rest
of the sheets...
eg. i want ot have the name of the sheets and with a way to make a click on
the name and go directly to the sheet
Do you have any good thoughts?

Thanks in advance
Manos
 
You could try the index that is built into XL.

Right click on any of the directional arrows that are to the left of the
sheet names.
This gives you a list of about 15 sheet names with the option to expand to
an infinite scrolling list of all the sheets in the WB.

This list is in the order that the sheets are in the WB.
Any sorting must be done by manually moving the sheets within the WB ... If
this isn't good enough you will have to use David McRitchie's TOC as
recommended by Paul B.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If yo
 
Back
Top