Excel Sheet Index Macro
Ever wished there was an easy way to create a list of all the tabs in your Excel workbook, with hyperlinks to let you jump to any sheet instantly and then back to the list again?
In this video I share two macros you can add to your Quick Access Toolbar, that will let you do just that:
*** Sheet Index macro: creates an index of all sheets with hyperlinks
*** Goto Index macro: go back to the Index sheet / back to previous sheet
Contents:
0:00 Overview of the two macros
0:35 Example workbook with lots of sheets
1:36 How to add the Sheet Index macro to your Quick Access Toolbar
3:26 How to add the Goto Index macro to your Quick Access Toolbar
5:11 Downloadable e-book for directions to enable and install macro code on your Excel
You can find the free code you need for these macros listed here on my website:
https://integralexcel.net/sheet-index...
For step by step directions on how to enable macros and install the code in your Excel, download my e-book Making The Most Of The Quick Access Toolbar In Excel:
https://www.amazon.co.uk/Making-Quick...
If you found this video helpful, please like and subscribe to this channel stay up to date with my new videos. Thanks for watching.