Anne,
That is very helpful, in general thank you.

The problem is that each part number has four prices. So qty doesn't
work in this instance. What I wanted to do was be able to enter a
number into the appropriate column & cell (i.e. part#,daily rate) and
have that number multiplied by the price already entered into the price
sheet in the same work book.

I don't know if this makes sense or not. Basically I have a price list
and now I would like a nearly identical sheet that references the
prices list for certain cells. I know this can be done and probably
isn't that hard...I just don't have the lingo for this stuff yet.


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile: http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640