Use this code to create Macro Code 👇 Sub CreateTOC() 'Created by @vamsi.excel 'This VBA code will create/refresh a table of contents. 'Just click it... and get it done!! ' ' Dim lngIdxRow As Long Dim lngSrNo As Long Dim objWS As Worksheet Dim objTOCSht As Worksheet 'In following code, change name of the index sheet within the double quotes with your index sheet Set objTOCSht = ThisWorkbook.Sheets("Contents") lngIdxRow = 2 lngSrNo = 1 'Follwing code will create a Table of Contents With objTOCSht

Microsoft Excel - Working with spreadsheets on a phone...

Learn how to apply styles in Microsoft Excel.