ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Make dropdown item list in invoice sheet (https://www.excelbanter.com/new-users-excel/179169-make-dropdown-item-list-invoice-sheet.html)

tim

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




Ron Coderre

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






tim

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