Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an Index Sheet
I have a workbook with X number of worksheets in it, what I am trying to do
is have the code scroll thru the each of the sheets get the name and place it on an index sheet as a link to that particular worksheet, the user can then click on one of the names and be taken directly to the worksheet. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an Index Sheet
If he is not around (I have not seen him yet today) Jim Cone has some great
prebuilt software for doing just that. He gave me a copy but I am uncomfortable distributing it as it is not my work. If you dropped him a line directly (as I did) I am sure he would be willing to share it. -- HTH... Jim Thomlinson "Nigel" wrote: I have a workbook with X number of worksheets in it, what I am trying to do is have the code scroll thru the each of the sheets get the name and place it on an index sheet as a link to that particular worksheet, the user can then click on one of the names and be taken directly to the worksheet. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an Index Sheet
You can find some code also at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm Nigel wrote: I have a workbook with X number of worksheets in it, what I am trying to do is have the code scroll thru the each of the sheets get the name and place it on an index sheet as a link to that particular worksheet, the user can then click on one of the names and be taken directly to the worksheet. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create an index for my book? | Excel Discussion (Misc queries) | |||
dragging the row contents of all the sheet to a Index sheet | Excel Discussion (Misc queries) | |||
Create Bar code Sheet w/lookups, index/match | Excel Worksheet Functions | |||
hyperlinks to create an index | Excel Discussion (Misc queries) | |||
Create worksheet index | Excel Programming |