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.
Something like this,
Now, we all know that you can use HYPERLINK() function to create a hyperlink in Excel. Here is a detailed tutorial on hyperlinks in Excel.
But, how do we make the hyperlink dynamic?
Very simple, we just count how many values our list has and then link to the last cell’s address accordingly. See this video tutorial to understand how you can do it.
Dynamic Hyperlinks in Excel – Video Tutorial
Download Example Workbook on Dynamic Hyperlinks
Click here to download this example workbook. Play with it to understand how this technique works.
Do you use Hyperlinks? Share your tips
I use hyperlinks in my Excel workbooks all the time. They are easy to create and they make my workbooks more accessible. Adding a hyperlink is the easiest way to impress your audience.
What about you? Do you use hyperlinks? What are your favorite uses / tips? Please share using comments.
More Tutorials on Hyperlinks in Excel
Check out these tutorials to learn more about Hyperlinks in Excel
- Introduction to Excel Hyperlinks
- Creating a Table of Contents in Excel Workbook (and other tips)
- Creating a Birthday Reminder using Excel
- What is a Picture Link & How to use it?
PS: that is my hand-writing in the image above. I bought Genius Slim Tablet
on my way back from Singapore. So I am playing with it.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.