Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel - Dynamic Table of Contents

  • 30-01-2019 12:55PM
    #1
    Registered Users, Registered Users 2 Posts: 1,799 ✭✭✭


    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.


Comments

Advertisement