Sometimes I find that I really need to torture Excel in the name of work. At the moment I am working on an Excel file with about 40 worksheets, and multiple pages on each sheet; all up it will weigh in at about 200 page mark.
One of the things that I was asked to do was to create a table of contents for this monster. That’s not something that I’m keen on doing manually – especially as I still need to play with the page formatting!
Anyway a bit of googling turned-up a macro that creates and updates an Excel table of contents [^]. The results aren’t pretty, but it is something that I work with and it sure beats keying in the numbers each month.
