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/116164-updating-linked-cells-after-inserting-row.html)

BPH

updating linked cells after inserting a row
 
Is there a way to automatically update linked cells if you insert a row into
the source worksheet? I have a main worksheet and a second sheet that has
various links to the main sheet, but if I insert a row in the main sheet I
have to manually copy and paste the new row as a link in the second sheet. I
am trying to find a way to automatically do this. Any ideas??

BPH


All times are GMT +1. The time now is 06:58 PM.

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