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.

In article <(E-Mail Removed)>,
(E-Mail Removed) 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

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