Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating table of content in excel workbook
Hello, I have a workbook with approx 35 sheets, the first sheet is
named "TOC". I am trying to create a table of worksheets in this TOC sheet. In colum A i am entering the relative position of the sheet, that is first sheet, second sheet and the next colum B, i am entring the worksheet name against the colum A, its position, to give me a table of worksheet name in order of their appreance.THe challenge is that I can get the worksheet name by running the macro, but I am unable to create thie positions 1,2 3 4 if the worksheet position is changed.SO I end up geting the name of worksheets first and then updating the numeric sequence. Can there be a VBA code to do this. Any help is geratly appreciated. Vivek |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating table of content in excel workbook
The free Excel add-in "XL Extras" will create a table of contents
for all sheets in the workbook and hyperlink the sheet name to the sheet. It adds a new menu item to the Insert menu - "Table of Contents". The add-in can also sort the workbook sheets and do other stuff. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA wrote in message Hello, I have a workbook with approx 35 sheets, the first sheet is named "TOC". I am trying to create a table of worksheets in this TOC sheet. In colum A i am entering the relative position of the sheet, that is first sheet, second sheet and the next colum B, i am entring the worksheet name against the colum A, its position, to give me a table of worksheet name in order of their appreance.THe challenge is that I can get the worksheet name by running the macro, but I am unable to create thie positions 1,2 3 4 if the worksheet position is changed.SO I end up geting the name of worksheets first and then updating the numeric sequence. Can there be a VBA code to do this. Any help is geratly appreciated. Vivek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel |