dependency changes after row insert
I have a collection of worksheets that I set up, where entries for one sheet
are updated from another worksheet. In order to ensure that I can re-track
data entries and amounts, I have placed hyperlinks to an off-print section of
each worksheet so that I can quickly page from one spot of a worksheet to
another. By entering an exact cell referencing, when I page to a sheet using
the link, the resulant sheet has the targeted cell outlined. So far, so good,
and things are working well. However:
I'm wondering what happens when one inserts a row anywhere in a sheet, if
that disrupts the hyperlinking. I.e., is there anthing that a person needs to
do to ensure that the linkage reflects correct cell addressing?
|