Gord Dibben,
Wouldn't you place a hyperlink on each sheet, back to the Index Sheet?

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule
<<Previous Text Snipped to Save Bandwidth When Appropriate


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Sounds like you are creating an Index Sheet.

You can do it by making each name a hyperlink to the appropriate sheet.

My question is............how do you propose to get back to that original
sheet
so's you can pick another name from the list?

If you right-click on the navigation arrows at bottom left you will get a
list
of 15 sheets and "more sheets".

Selecting one of those will jump you to that sheet.


Gord Dibben MS Excel MVP


On Fri, 25 Jan 2008 15:30:23 +0000, steve12345

wrote:


Hello
Thanks for looking at this:
I want to list a number of names on sheet one of a workbook and I want
to be able to click on a name and it take me to another worksheet, in
the same workbook which is linked to that name.
Can I do it?
All help is much appreciated
Thanks
Steve