Workbook Index Sheet

[SloopJohnB]

Please help, I will like to have an Index Sheet at the front of the workbook with a hyperlinks to the individual sheets.

Thanks John

[alansidman]

Look at this tutorial by Susan Harkins.

http://www.techrepublic.com/blog/mic...ng-hyperlinks/

[sktneer]

Please find the attached sheet. Is this what you want?

[Winon]

Hi SloopJohnB,

Try the attached sample Workbook.

Regards

[Tony Valko]

One way...

Let's assume you have a sheet named Index which is a table of contents for the sheets in your file.

You have a sheet named Sheet1.

In the Index sheet in cell A2 enter this formula:

=HYPERLINK("#Sheet1!A1","Sheet1")

I assume you'll also want hyperlinks on the sheets that take you back to the Index sheet. So, on Sheet1 cell A1 enter this formula:

=HYPERLINK("#Index!A1","Index")

[Tony Valko]

Whenever you post a link to a file with no explanation...

http://www.excelforum.com/showthread...=1#post3325291

[martindwilson]

to add to alansidman what that tutorial doesnt say is you need to select a blank cell when creating the link any one will do
otherwise it creates one with the name of whatever's in the cell and you cant edit as described

to add to tony's post if you have a list of sheets say sheet1 in a1,sheet2 in a2 and so on
you can reference the cell instead of typing it in just fill down
=HYPERLINK("#"&A1&"!A1",A1)
=HYPERLINK("#"&A2&"!A1",A2)
=HYPERLINK("#"&A3&"!A1",A3)

[Tony Valko]

Looks kind of redundant?

Data Range

	A	B
1	Sheet1	Sheet1
2	Sheet2	Sheet2
3	Sheet3	Sheet3

Maybe change the friendly_name argument with the word Go.

[Tony Valko]

=HYPERLINK("#"&A1&"!A1","Go")

Data Range

	A	B
1	Sheet1	Go
2	Sheet2	Go
3	Sheet3	Go

[Winon]

Hello SloopJohnB,

Sorry, I have missed the Index Sheet request.

Please try the attached Workbook now.

Regards

[Winon]

@ sktneer,

Hi, thank you for rewarding me with such a nice Reputation.

I shall look out for you as well in the future.

Regards

[SloopJohnB]

Thanks guys.

[Tony Valko]

You're welcome!

[Winon]

Hello SloopJohnB,

You are welcome.

It would have been nice to hear from you, what solution best solved your issue, for the benefit of all the contributors to this thread.

Regards

[SloopJohnB]

I used the Ctrl "K" method, but I will have a look at your method as I like the Index return button when I have more time.

Thanks for your input.

[Tony Valko]

FWIW...

I have 100's of Excel files using an index sheet (or table of contents) with the formula type of hyperlinks I describe in post #5.

Hyperlinks to the individual sheets and then hyperlinks back to the index sheet.

Works vey well.