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 |
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 |
All times are GMT +1. The time now is 05:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com