ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mirroring a data range (https://www.excelbanter.com/excel-discussion-misc-queries/226277-mirroring-data-range.html)

Skorpishor

Mirroring a data range
 
Hi
I have two worksheets in the same excel file.
The first one is the one were I made a lot of changes, as input data.
In the second one I have to use the data from the first to make some
calculation.
My problem is that I have to add some new rows in my "input" data. How can I
refer this so that when I add a row in the first sheet this will be copied in
the second sheet?
Try a small grafical explanation
First sheet Second
A A
B B
C C
D D
If I add a new row in the first
A
B
X
C
D
this has to be "mirored" also in the second sheet


All times are GMT +1. The time now is 07:45 AM.

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