Forum Discussion
Alphabetized Index of Worksheets
I am trying to index a large workbook, but I want the index to automatically alphabetize itself for easy usage. (I know this can be done because one-upon-a-time I found it on a forum. But I lost it...
Perhaps you can use my free sheettools add-in, which inserts a Table of Content:
https://jkp-ads.com/downloadnl.asp#SheetTools
It does not sort them, but once the table is there, it is just one click to sort it.
https://jkp-ads.com/downloadnl.asp#SheetTools
It does not sort them, but once the table is there, it is just one click to sort it.