K
Ken Poberezny
Hi,
I have two sheets 'cost' and 'materials' on which the constants are
placed
A cell on 'cost' has this formula =C9*materials!D37
I now need to copy this down any number of times, the first repeat reads
=C10*materials!D38, whereas I want it to read =C10*materials!D37
I've tried this =C9*materials!$D37 but get =C10*materials!$D38
How do I keep the cells not increasing?
thanks.
I have two sheets 'cost' and 'materials' on which the constants are
placed
A cell on 'cost' has this formula =C9*materials!D37
I now need to copy this down any number of times, the first repeat reads
=C10*materials!D38, whereas I want it to read =C10*materials!D37
I've tried this =C9*materials!$D37 but get =C10*materials!$D38
How do I keep the cells not increasing?
thanks.