Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/06/04/variable-hyperlinks/
Posted
Jun 04 2008, 02:53 PM
by
Daily Dose of Excel