Create a List of Sheet Names using Power Query... With 2 ways Navigation
When you have a workbook with lots of worksheets it's very useful to create an Index of All Sheet Names and be able to Navigate to any of these worksheets and back to the Index.
There are 3 methods for doing this:
Either by Using Functions
Or By using a VBA code
Or By Using Power Query
In this tutorial I am using Power Query
You can download the Start file and follow along by clicking on the link here below:
https://www.amazon.ca/clouddrive/shar...
To watch the tutorial in which I use Functions Click on the Link:
• Extract a List of Worksheet Names Usi...
To watch the tutorial in which I use a VBA Code Click on the Link:
• Simple VBA Code to create a List of A...
If you find value in this tutorial give it a thumb up, and hit the “Subscribe” button to be notified when new videos are posted