Insert row
 

Hi

Can anyone help with this problem?

I have a worksheet of 500 names.
Columns A-P contain user inserted data.
Column Q contains the formula (typical) =IF(COUNTIF(E5:P5,"")<12,"1","")
Column R contains (typical) =B5

When I insert a row, the formula in Column R is copied OK.
The formula in column Q is not copied.

Can anyone say why this is happening?

Thanks

georgeporge