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!