Insert row

G

georgeporge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Construct table from selected rows 4
Averageifs - criteria is cell is not blank 1
Counting and multiplying 3
Help with determining # of days from certain dates 2
Formula's won't read copy / pasted data ? 2
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
Help with Sumproduct searching cell contents 2
automatically numbering rows 2

Top