updating linked cells after inserting a row
I have a worksheet that is linked to another worksheet in the same workbook.
I use this setup so I only have to enter updates into the first worksheet,
but the second is automatically updated. I have one problem. If I insert a
row into my first worksheet the second worksheet won't show the data from the
added row unless I copy and paste a link. Is there a way to update the
linked sheet automatically when I insert a row into the frst sheet without
always copying and pasting a link?
BPH
|