Constant required

[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.

 

[Steve]

Ken Poberezny penned:

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.

C9*materilas!$D$37

 

[Steve]

Steve penned:

Ken Poberezny penned:

C9*materilas!$D$37

of course it should read

C9*materials!$D$37

I need to invest in a new set of fingers.
--
Steve

In theory, there is no difference between theory and practice; In
practice, there is.
- Chuck Reid

 

[Ken Poberezny]

Steve penned:


of course it should read

C9*materials!$D$37

I need to invest in a new set of fingers.

thanks

 

[Eduardo]

Hi,

=C9*materials!$D$37