Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions |