| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink with name from cell
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink from one.xlsx cell to another two.xlxs cell & click back | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| script to hyperlink and reference a cell value in the hyperlink | Excel Programming | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| Copy hyperlink from one cell to/as hyperlink in another cell | Excel Worksheet Functions | |||
Threaded Mode
