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!

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

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

--
Regards,
Tom Ogilvy



"hyperlink with name from cell" wrote:

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!

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


"hyperlink with name from cell" wrote:

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!

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)

"Tom Ogilvy" wrote:

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

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

--
Regards,
Tom Ogilvy



"hyperlink with name from cell" wrote:

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!

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

Worked for me.

--
Regards,
Tom Ogilvy


"hyperlink with name from cell" wrote:

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)

"Tom Ogilvy" wrote:

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

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

--
Regards,
Tom Ogilvy



"hyperlink with name from cell" wrote:

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!

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?

"Gary''s Student" wrote:

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


"hyperlink with name from cell" wrote:

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!

got it too work...THANKS!

"hyperlink with name from cell" wrote:

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?

"Gary''s Student" wrote:

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


"hyperlink with name from cell" wrote:

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!