Multiple Worksheets help

[Pilgrimav8r]

I'm not doing very well here so any help at all is greatly appreciated.

I don't want to use a macro.

I have a single spreadsheet which has multiple worksheets in it 100+. On about worksheet 7, I have put in an index (titles and worksheet number).

All I'm trying to do is click on the index cell on the index worksheet and get it to direct me straight to the corresponding worksheet.

Many thanks in anticipation

 

[Pilgrimav8r]

Try this experiment...

Open a new file that still has the default sheet names Sheet1, Sheet2, Sheet3 etc.

Enter this sheet name in cell A2: Sheet2

Enter this formula in cell B2:

=HYPERLINK("#Sheet2!A1",A2)

Now, click on cell B2.

You're taken to Sheet2 cell A1.

Biff I tried that and it did not work - perhaps I should tell you its Win 7 and excel 2007?

Steve[/QUOTE]

 

[Pilgrimav8r]

Mark could I ask you to simplify that - I'm pulling my hair out here

Steve

 

[T. Valko]

Biff I tried that and it did not work - perhaps I should tell you its Win 7 and excel 2007?

Steve

[/QUOTE]
I don't know why it wouldn't work. Being connected to the internet shouldn't have anything at all to do with it since you're not hyperlinking to an internet location.

If you do need some VBA method then someone else will need to help you with that. I'm not much of a programmer.