Constant required
 

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.

Constant required
 

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

Beware of all enterprises that require new clothes.
- Henry David Thoreau

Constant required
 

Steve penned:
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

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

Constant required
 

In article ,
says...
Steve penned:
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

of course it should read

C9*materials!$D$37

I need to invest in a new set of fingers.

thanks

Constant required
 

Hi,

=C9*materials!$D$37

"Ken Poberezny" wrote:

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