hyperlink with name from cell

[Guest]

I have a workbook with >300 worksheets. I just created a dropdown to get to
a specific worksheet fast. But, I have just read about using hyperlinks and
I am intrigued! My first page is set up like a TOC (cell A1 to A300
"=NameOfSheet!B2"). I would like to set up a hyperlink for each sheet and
have the text from a certain cell show up as the name. In the end I would
like to go to my TOC page, click on a name, and then be taken to the
appropriate sheet. This is all new to me.....I am using XL200. Thanks!

 

[Guest]

maybe check out David McRitchie's site on building a TOC with hyperlinks:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Guest]

You have two really good options:

1. create a Named Range for each place you want to go to. You go there by
pulling down the address pull-down just to the left of the formula bar. This
options is good because it does not use a lot of worksheet space


2. create a list of hyperlinks in the worksheet like:
=HYPERLINK("[Book1]Sheet3!Z100","zoo")

 

[Guest]

I created a "Budget" workbook with June, July, & August workshhets, and added
the following hyperlink in August. I got a pop-up saying "Cannot open the
specified file". What am I doing wrong?
=HYPERLINK("[Budget]June!E56", E56)

 

[Guest]

=HYPERLINK("[Budget.xls]June!E56",E56)

Worked for me.

--
Regards,
Tom Ogilvy

I created a "Budget" workbook with June, July, & August workshhets, and added
the following hyperlink in August. I got a pop-up saying "Cannot open the
specified file". What am I doing wrong?
=HYPERLINK("[Budget]June!E56", E56)

maybe check out David McRitchie's site on building a TOC with hyperlinks:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Guest]

OK, I got part of option 2 to work. Instead of putting "zoo", I want to have
the text from B2 ( the title) to show, so I put
=HYPERLINK("[_Tox Buffer Calculations.xls]MBF01!B2","MBF01!B2")
How do I make "MBF01!B2" = the title?

You have two really good options:

1. create a Named Range for each place you want to go to. You go there by
pulling down the address pull-down just to the left of the formula bar. This
options is good because it does not use a lot of worksheet space


2. create a list of hyperlinks in the worksheet like:
=HYPERLINK("[Book1]Sheet3!Z100","zoo")

--
Gary''s Student
gsnu200705

I have a workbook with >300 worksheets. I just created a dropdown to get to
a specific worksheet fast. But, I have just read about using hyperlinks and
I am intrigued! My first page is set up like a TOC (cell A1 to A300
"=NameOfSheet!B2"). I would like to set up a hyperlink for each sheet and
have the text from a certain cell show up as the name. In the end I would
like to go to my TOC page, click on a name, and then be taken to the
appropriate sheet. This is all new to me.....I am using XL200. Thanks!

 

[Guest]

got it too work...THANKS!

OK, I got part of option 2 to work. Instead of putting "zoo", I want to have
the text from B2 ( the title) to show, so I put
=HYPERLINK("[_Tox Buffer Calculations.xls]MBF01!B2","MBF01!B2")
How do I make "MBF01!B2" = the title?

You have two really good options:

1. create a Named Range for each place you want to go to. You go there by
pulling down the address pull-down just to the left of the formula bar. This
options is good because it does not use a lot of worksheet space


2. create a list of hyperlinks in the worksheet like:
=HYPERLINK("[Book1]Sheet3!Z100","zoo")

--
Gary''s Student
gsnu200705

I have a workbook with >300 worksheets. I just created a dropdown to get to
a specific worksheet fast. But, I have just read about using hyperlinks and
I am intrigued! My first page is set up like a TOC (cell A1 to A300
"=NameOfSheet!B2"). I would like to set up a hyperlink for each sheet and
have the text from a certain cell show up as the name. In the end I would
like to go to my TOC page, click on a name, and then be taken to the
appropriate sheet. This is all new to me.....I am using XL200. Thanks!