Creating a Variable Hyperlink in Excel

This is cool!

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.

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:
oz@datascopic.net

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *