- The columns that aren't replicating are not directly beside each other, they are mixed in with ones that are replicating.
- I have selected the entire workbook and made sure cell formatting is set to general. I have tried with the set to numbers as well. All the cells formulas result in number data or true/false columns. Some true/false columns are replicating, most are not.
- The true/false columns that aren't replicating I changed to try and output 1 or 0 and they still did not replicate.

=IF(B50=0,FALSE,ISEVEN(B50))

=IF(B50=0,FALSE,ISODD(B50))

=IF(J50=TRUE,1,0)

=IF(B50=0,0,IF(B50<=18,1,0))

=IF(B50=0,0,IF(B50>=19,1,0))

=COUNTIF($B$1:$M$1,B50)

=COUNTIF($B$2:$M$2,B50)

=COUNTIF($B$3:$M$3,B50)

=COUNTIF($B$4:$M$4,B50)

=COUNTIF($B$5:$M$5,B50)

=COUNTIF($B$6:$M$6,B50)

And formulas that aren't auto replicating:

=IF((C50+C49+C48)=0,TRUE,)

=IF((D56+D55+D54)=0,TRUE,)

=IF((H56+H55+H54)=0,TRUE,)

=IF((K56+K55+K54)=0,TRUE,)

=IF((M56+M55+M54)=0,TRUE,)

=IF((O56+O55+O54)=0,TRUE,)

=IF((Q56+Q55+Q54+Q53+Q52+Q51)=0,TRUE,)

=IF((S56+S55+S54+S53+S52+S51)=0,TRUE,)

=IF((U56+U55+U54+U53+U52+U51)=0,TRUE,)

=IF((W56+W55+W54+W53+W52+W51)=0,TRUE,)

=IF((Y56+Y55+Y54+Y53+Y52+Y51)=0,TRUE,)

The first two of the not working list work directly from the inputs from the user which are numbers. The rest work off the results of formulas in other cells. I have tried changing these to =IF((C50+C49+C48)=0,TRUE,FALSE) or =IF((C50+C49+C48)=0,1,0) and they still won't replicate.

However the formulas DO work and I can drag the formulas down with the cross to fill the next line and they continue down correctly. I just don't know why that bottom list isn't auto replicating so I don't have to drag down the line every time I put in a new line. Again, they are not blocked together either. They don't work in columns E, F, I, L, N, P, R, T, V, X, Z, AB.

I don't know if there is some formula problem preventing those certain columns from replicating or what. Someone in another forum mentioned using a worksheet_change event, but I basically don't know anything about writing VB in excel. If that is something that would be easily written, all it would have to do is if there is a change to any cell in column D, then E:AB need to be copied down from the prior row. For example, a change in D10 would result in E9:AB9 to be copied to E10:AB10.

Thanks in advance for the help!