Excel Table of Contents for Sheet Tabs with Hyperlinks | Create Automatically | Office Script Macro
In this Microsoft Excel video tutorial I demonstrate how to use an Office Script to automatically create a table of contents including hyperlinks for each worksheet tab. Download the featured file here. Here is the Office Script code: function main(workbook: ExcelScript.Workbook) { //If TOC already exists, delete it if (workbook.getWorksheet(“Table of Contents”)) { let oldTOC… Read More »Excel Table of Contents for Sheet Tabs with Hyperlinks | Create Automatically | Office Script Macro