BrizBunny Rotating Header Image

March 26th, 2011:

Excel Table of Contents

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.

Excel Table of Contents