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:
www.amazon.ca/clouddrive/share/ZYfNMo26BkaTxXVMrcXKjR2ipKtdjS6qVs6JPNAeHV7
To watch the tutorial in which I use Functions Click on the Link:
kzitem.info/news/bejne/p5uBzYuJfWp6ipg
To watch the tutorial in which I use a VBA Code Click on the Link:
kzitem.info/news/bejne/t2aBzJaDk5OQo44
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
Негізгі бет Create a List of Sheet Names using Power Query... With 2 ways Navigation
Пікірлер: 37