Creating a Dynamic Hyperlink in Excel
This is cool (and complicated)!
The problem: 11 worksheets and hundreds of codes
Objective: the ability to type a code and be taken directly to that code wherever it is in the workbook.
It's like the Find/Select feature in Excel, the user wanted to stay in the worksheet and minimize use of the ribbon. We needed a dynamic hyperlink
One thing to know about creating hyperlinks.
Regular references to cells can look like: Sheet3!B5
But hyperlinks need to include a '#." Therefore:
#Sheet3!B5
This video shows how to make the dynamic hyperlink. It's crazy! We have to use COUNTIF, MATCH, OFFSET, INDIRECT, HYPERLINK and helper columns.
Download the workbook here:
http://datascopic.net/hyperlink
This video was recorded at Casa de Montecristo by Cigar Inn at 2nd & 54th in New York City.
Contact me:
[email protected]
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2