I have made a drop down menu (by defining a name)

I would like to make it so it changes the price in a different column
when i change the drop down menu item

for example i have

ITEM QUANTITY PRICE

i want to make it so that when I choose the item from the drop down
menu and enter in the quantity it will calculate the total price

for example if i choose a boxed pin from the item menu and then type in
2 in quantity i want it to show up as $20 in the price ($10 each)

is there a way to do this?

thanks


--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile: http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385953