See Debra Dalgleish's instructions at her website:
http://www.contextures.com/xlOrderForm01.html
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"tim" wrote in message
...
Hi all
I have made an invoice in sheet1 and have list of items in sheet2.
How can I make a dropdown list in invoice showing sheet2 items and at the
same time get the unit price for the item too?
i.e.
In Sheet1(Invoice) : B20 = Items Descritpion C20 = Unit Price
in Sheet2(Stock List) : A2 = Items description C2 = Unit Price
regards