In this video, we create a drop-down list of hyperlinks to other sheets in the workbook.
I have created videos in the past on the HYPERLINK function and creating dynamic links from text on the worksheet.
In this video, though it is selected from a dropdown. A great idea for a report, table of contents or dashboard page. Where space is limited but you want simple and dynamic ways to navigate.
For this to work, we got smart we some Excel formulas using the INDIRECT and ADDRESS functions.
5 great INDIRECT function examples – https://youtu.be/rYdAsxf9EG0
Find more great free tutorials at;
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
