Does Excel produce a table of contents?
I have an Excel workbook with many worksheets. How can I make a table of
contents in a sheet that picks up my worksheets? |
Does Excel produce a table of contents?
Sounds like you're looking to build a table of contents?
One good way is Jim Cone's fine, free product (his XL Extras add-in) at his: http://www.realezsites.com/bus/primi...e/products.php Scroll right down to the bottom of the page for the download link: XL Extras - release 1.21 ... Download A collection of additional features including... **create table of contents with hyperlinks to each sheet Jim's add-in will do exactly what you're looking for (and much more ..) After installing, just click Insert Table of Contents (new menu item), then sit back and watch Jim's magic go to work! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Pronk" wrote: I have an Excel workbook with many worksheets. How can I make a table of contents in a sheet that picks up my worksheets? |
Does Excel produce a table of contents?
John
I have code at the bottom of this page http://www.nickhodge.co.uk/vba/codeexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "John Pronk" wrote in message ... I have an Excel workbook with many worksheets. How can I make a table of contents in a sheet that picks up my worksheets? |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com