By Dynamic Hyperlinks I mean links that changes based on the selection (or any other user action) Suppose I have the data set as shown below:

This is the back end data, and I have a summary sheet where I have drop downs where the person can select the Month. The idea is to update the hyperlink with the selections so that it takes the user to the right cell when the hyperlink is clicked. Something as shown below

# tells the formula to refer in the same workbook Data!B is the reference of sheet name and column name MATCH(B3,Data!$B$3:$B$26,0) gives the position of the matching month in the list. 2 is added to it as there are 2 data begins from the third row. For example, in case of January 2012, Match formula returns 1, and adding two returns 3. Hence it refers to B3

This is an amazing trick that can come very handy in creating Excel dashboards. Try it Yourself.. Download the file from here

How to Quickly Find Hyperlinks in Excel (using Find and Replace). How to Quickly Remove Hyperlinks from a Worksheet in Excel. Quickly Create Summary Worksheet with Hyperlinks in Excel. Excel INDIRECT Function

=HYPERLINK(“#’”&$A4&”‘!A1″,”→”) Gives an arrow that when clicked takes you to cell A1 of the sheet named in A4… brilliant! Can you explain it in detail ?