Adding/Deleting Rows between linked Worksheets

[Sanaz E]

Okay guys, I've been able to paste link (through copy-paste
special-paste link feature) between two worksheets. That is, I have
been successful in having paste linked values automatically update
between the two worksheets.

What I haven't figured out is how to add a new row or delete a row and
have that reflect between the two worksheets that are paste linked. I
know it throws off the whole logic when you add a row because the
second worksheet is referencing its source e.g. A1 or B7. And once you
delete lets say row 1 or row 7, the logic has been thrown off. How
does one overcome this hurdle? Is this something Excel cannot deal
with.

 

[RagDyer]

Try revising your linking formulas to something like this:

FROM:
=Sheet2!$A$4
TO
=INDIRECT("Sheet2!A4")

Or, perhaps group your sheets together before you make any insertions or
deletions.

Depends on exactly which way you want to go.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Okay guys, I've been able to paste link (through copy-paste
special-paste link feature) between two worksheets. That is, I have
been successful in having paste linked values automatically update
between the two worksheets.

What I haven't figured out is how to add a new row or delete a row and
have that reflect between the two worksheets that are paste linked. I
know it throws off the whole logic when you add a row because the
second worksheet is referencing its source e.g. A1 or B7. And once you
delete lets say row 1 or row 7, the logic has been thrown off. How
does one overcome this hurdle? Is this something Excel cannot deal
with.