Dynamic Hyperlinks in Excel
http://chandoo.org/wp/2011/07/14/dyna...
During one my recent training programs, a participant asked an interesting question.
"I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list."
In this video, you can learn how to create such dynamic hyperlinks in Excel.