Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a Table of Content in Excel
Hello,
I would like to create a dynamic table of content in excel, is this possible? thanks for your support |
#2
|
|||
|
|||
Depends on what you mean...
If you meant you want a worksheet that serves as a table of contents to the other sheets, David McRitchie has some code you may like that builds hyperlinks to cell A1 of those other sheets. In fact, you could see how David set up the hyperlinks and use that for your table of contents. http://www.mvps.org/dmcritchie/excel/buildtoc.htm But I'm not sure what dynamic means. If you want to build a hyperlink that points at a certain cell--no matter where you move it, try giving that cell a nice name (insert|name|define), then use that in the hyperlink. Michiel Junge wrote: Hello, I would like to create a dynamic table of content in excel, is this possible? thanks for your support -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
paste excel table to word | Excel Worksheet Functions | |||
Paste table from excel to word | Excel Worksheet Functions | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel |