Auto-Workbook Directory for Excel - Table of Contents
Excel Project
Questions? Contact Us
Create a Directory Worksheet (Table of Contents) automatically using VBA and macros in Excel. This worksheet includes a summary of all worksheets in the workbook as well as links to those worksheets and links from those worksheets back to the Dashboard worksheet for quick navigation.
This system is perfect for people who often export reports that contain a lot of worksheets and want an easy way to navigate through all of them, as well as a simple way to view a summary of important information from all of those worksheets in one place.
As usual, I walk you through all of the steps that you need to get this setup up and running for your workbook.
To build even more powerful VBA projects or further customize this one, checkout the full VBA Course.