Hi,
This formula has references to other sheets in the same file.
I have this formula in A1 : =IF('47'!$B$1<0;'47'!$B$1;" ")
I have this formula in A2 : =IF('48'!$B$1<0;'48'!$B$1;" ")
and so on and so on.
I want to copy this formula in about 50 rows. So i tried to click it and
move it to others cells. But the formula stays the same. I thought the
numbers 47 and 48 should increase with 1, but they don't.
How could I solve this ?

Bart