Column reference changes if you drag or copy the formula to the RIGHT (from
A1 to B1, C1 and so on, IF you do not have $ before the column reference.
Row reference changes if you drag or copy the formula DOWN (from A1 to A2,
A3 and so on) IF you do not have $ before the row reference.

So A1 will change to B1 (right) and A2 (down)
$A1 will reamain $A1 (right) but change to $A2 (down)...
A$1 will be B$1 (right) and remain A$1 (down)

Hope I got all that right but you must have got the idea.
"keith" wrote:

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