Hyperlinks in Excel 2003 (2003)

Topic

New Reply

Ok, may be a stupid question……but is there such a thing as “dynamic” hyperlinks in Excel. For instance, if I set up a reference to a cell in another worksheet, and that data that I need to link to is moved to another cell, is there a way to set it up so that the link follows it to the new cell reference? We are linking items to data in another worksheet that is modified from time to time and we want to maintain the hyperlink. Thanks!

Reply | Quote

Replies

Give the cell you want to refer to a name (select the cell, and type the name in the address box on the left side of the formula bar, or select Insert | Name | Define…). You can create a hyperlink that refers to the defined name; it will still work if you drag the cell to another location.

Reply | Quote

Thanks, will give a shot tomorrow at work!

Reply | Quote