I want to know how to copy the formula below to the next cell down a column,
but I want it to increment the column reference from C to D to E then F and
so on, hence the reason I've not $ signed the column referenece.

=IF('Shift plan'!C$6=0,"",'Shift plan'!C$6)
=IF('Shift plan'!D$6=0,"",'Shift plan'!D$6)

But what I get is:

=IF('Shift plan'!C$6=0,"",'Shift plan'!C$6)
=IF('Shift plan'!C$6=0,"",'Shift plan'!C$6)
=IF('Shift plan'!C$6=0,"",'Shift plan'!C$6)

Why does it not increment the column reference and how do I get it to
increment?

Thanks in anticipation Keith