Skip to content

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

    Split Data into Separate Worksheets Using ChatGPT to Write Office Script

      In this Microsoft Excel video tutorial I use ChatGPT to write an Office Script that splits data (currently held in a single worksheet) into multiple worksheets based on a column value. Download the featured file here. Here’s the code that ChatGPT came up with: function main(workbook: ExcelScript.Workbook) { const worksheet = workbook.getActiveWorksheet(); const usedRange =… Read More »Split Data into Separate Worksheets Using ChatGPT to Write Office Script