ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   updating linked cells after inserting a row (https://www.excelbanter.com/excel-discussion-misc-queries/115955-updating-linked-cells-after-inserting-row.html)

BPH

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


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com