Hello, this is a complicated one... I have a sheet which is the base sheet
for the file, I have 3 more sheets which contain values and formulas which
feed the base sheet. In this way:

BASESHEET
Week (1)
Activity - Quantity - $/unit - Total
1.1 Walls - (100) ft2 - ($15)/ft2 - ($1,500.00)

Sheet 2: (Quantity)
Activity - (Week1) - Week2 - Week3
1.1 Walls - (100) - 100 - 150

Sheet 3: ($/unit)
Activity - (Week1) - Week2 - Week3
1.1 Walls - ($15.00) - $15.50 - $15.50

Sheet 4: (Total)
Activity - (Week1) - Week2 - Week3
1.1 Walls - ($1,500.00) - $1,550.00 - $2,325.00

I enter the activities in the Basesheet and the values for each week are
gathered through a HLOOKUP from the other sheets(2:4). The thing is that I
don't know a better way to do it so I got the code (1.1) on sheets 2:4 with a
plain =$A2 from BASE SHEET drag it down enough rows to not need more, and
enter the values for the corresponding weeks...

The thing is that when I want to add/delete a new row in the Base sheet, the
only way for the file to continue working appropiately is to manually
add/delete the corresponding rows in the other sheets and drag down formulas
when necessary. Is there a way to

Add rows to several sheets at the time keeping the formulas on the new added
rows, some how like a "mirror columns" from other sheet..?

thank you!



I hope I was able to explain myself with this, thanks!