S
sanaz7
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.
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.