I've been messing around in excel, learning it as I go, as an experiment
I started making an Invoice for my Pseudo company, it will have the
following fields

|Item. Desc. | Part Number | Quantity | Unit | Total |

I have created a drop down box for part number that will pull a list of
items off my "Items" worksheet, when I select a part number I want it to
pull the unit cost for that part number from the cell imediately next to
the part number on my "Items" worksheet and put it in the unit cost
field.

How might I go about this?


Thanks,
Lain


--
master_lain
------------------------------------------------------------------------
master_lain's Profile: http://www.excelforum.com/member.php...o&userid=35027
View this thread: http://www.excelforum.com/showthread...hreadid=547705