Drop Down list with calculations and values
Hello,
I can't seem to find the answer to this anywhere and hoping someone can help.
I have a document in Word 2010 that requires a set of drop down lists that self calculate. It would look like this
Qty Uniform Description Unit Cost Total
I would like to be able to put items such as Crew Shirt, Work Pants and Fleece Jacket under "Uniform Description" and have the "Unit Cost" auto fill with the appropriate amount i.e $5.00, $6.00, $10.00 then have the total column calculate the Unit Cost by the Qty entered.
Can anyone guide me on this one. I am okay with the total and qty calculations (or at least I think I am) it is the value in the "Uniform Description" I seem to be having trouble with.
Thanks!
|