![]() |
Make dropdown item list in invoice sheet
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 |
Make dropdown item list in invoice sheet
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 |
Make dropdown item list in invoice sheet
Thanks
that exactly I wanted. :) "Ron Coderre" wrote in message ... 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 |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com