Excel - Dynamic Table of Contents

Diceicle · 30-01-2019 1:55pm #1

I presume this is possible but info I've been able to see online so far is not hitting the mark.

I would like to create an excel Table of Contents (TOC) for a workbook.
The TOC should function like a Word TOC insofar as it should update page numbers 'itself' when a worksheet is a greater number of pages etc.

For sake of example if you imagine an end of year expenditure report for a large company with differing depts each on a separate tab:-

Logistics
Procurement
Sales
Marketing
Finance

They need to combine into 1 PDF with a TOC.

namenotavailablE · 31-01-2019 11:20pm

Does the attached do what you're looking for?

Box file: https://app.box.com/s/mtmqi7gu987be76ury4ff45urav8wojg

As you add sheets to the workbook, the TOC will update when you click on it [you MUST click on the TOC sheet to update the table of contents; also, I've assumed that the TOC sheet is the 'leftmost' sheet in the module code i.e. all the other sheets are to the right of the TOC sheet]

EDIT: I fixed a bug @ 11am 1 Feb in case anyone downloaded an earlier version

Excel - Dynamic Table of Contents

Comments