View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sarah1997
 
Posts: n/a
Default data validation lists and invoices


Is it possible to automatically populate a cell, for ex. "cost per
unit", when a selection is madde from a drop down list (data
validation) created from an inventory list of products? On my invoice I
want to have drop down box with all products, select product from list,
have price per unit automatically populated, enter manually number
used/sold, have formula calculate total price for total units...I just
can't figure out the auto population part. My product inventoru list
has about 250 items with varying prices. I copied the product list w/o
any prolems to the data validation part of the invoice. Any help/tips
advice welcome. Newbie.:)


--
sarah1997
------------------------------------------------------------------------
sarah1997's Profile: http://www.excelforum.com/member.php...o&userid=30498
View this thread: http://www.excelforum.com/showthread...hreadid=501507