building a master price list

  • Thread starter Thread starter Shane K
  • Start date Start date
S

Shane K

Hi,
I'm having some difficulty building a master price list
with all formula's on one sheet and the working data base
on another. On worksheet one I have listed all the
appropriate discount factors. On worksheet 2 I have all
the list prices per items. I want to be able to mulitply
all the list prices by on discount listed in worksheet 1
to one column in worksheet 2 to get the appropriate
price. However when I try to copy the formula to the rest
of the column it comes up with all zero's. Anyone have
any ideas what so ever?

Thanks,
Shane
 
Shane

I'm guessing here but........

With discount in Sheet1 D1

And Sheet2 Column A has the prices

In Sheet2 B1 enter =A1-(A1*Sheet1!$D$1)

Drag/copy this down Column B.

Note the Absolute reference for Sheet1!$D$1

The $ signs lock that cell reference as you copy down.

The A1 is Relative and will increment as you copy down Sheet2 Column B.

Gord Dibben Excel MVP XL2002
 
Gord,

You hit the nail on the head. Excellent work!! Thank you
very much you just saved me days of work!!!

Cheers,
Shane
 
Back
Top