Dynamic Hyperlinks in Excel to navigate between Worksheets

Adding a hyperlink to a specific worksheet or cell is an easy thing to do. But what if you need the hyperlink to be dynamic, no matter if you insert or delete sheets, change the order of sheets?
Or, if you start from a template sheet, and keep adding sheets, you need to have dynamic hyperlinks in the template sheet, that “knows” which is the next or previous sheet, without manually adjusting all hyperlinks.

Few things you should know:

You have multiple options to create a hyperlink (without VBA):

1. you can add a hyperlink to a cell, by right clicking that cell and selecting Hyperlink from right click menu;
2. add a hyperlink to a shape, by right clicking that cell and selecting Hyperlink from right click menu; (very similar to adding a hyperlink to a cell)
3. add a hyperlink in a cell using the Excel Hyperlink Function.

Read More