building a master price list

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
 
G

Gord Dibben

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
 
S

Shane

Gord,

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

Cheers,
Shane
 
Top