Index page
 

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

Index page
 

See replies in worksheet.functions

Please don't post the same article in multiple groups - it just
fragments your answers and wastes the time of responders.

In article ,
"Manos" wrote:

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



--
Email address ROT-13'd for spam reduction
see www.mcgimpsey.com/excel/groupspam.html to decode