Hyperlink References

[Mike McLellan]

I have an Excel workbook with a number of sheets within it - the first sheet
is a summary of the data contained in the subsequent sheets and contains
hyperlinks to cell references in each of those sheets. My problem is that
when I ad a row to one of the detail sheets, the hyperlink in the summary
sheet doesn't automatically update itself to reference the new cell address.
Is there any way that I can do this?

 

[Gary''s Student]

Consider assigning a Named Range to the destination cells. When you:
Insert > Hyperlink... > To a place in this document
The Name will be available.

This destination will adjust as rows/columns are added/removed

Also the =HYPERLINK() function can reference the Names as well.