Hi,

I have tow sheets and the seconde one is copying data twice from the first one as following:

=IF(ISBLANK('sheet1'!$A2),"n/a",('sheet1'!A2))
...
...
...
=IF(ISBLANK('sheet1'!$QA2),"n/a",('sheet1'!A2))
...
...
...

If I previously hold Ctr and then add/remove rows in Sheet1, the Sheet2 automatically updates only the data copied the first time (rows with - condition1), but the data copied the second time (rows with - condition 2) don't get updated.

I have tried to put rows with condition1 and rows with condition2 on two other different sheets and then copy everything on the third one - that didn't help either.

Is there a way to have everything updated automatically when removing/adding rows?

many-many thanks!