| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Macro - Make Dropdown List Temporarily Wider | Excel Discussion (Misc queries) | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| Make input in one column determine dropdown list in another. | Excel Discussion (Misc queries) | |||
| How can I set up to chose more than 1 item from a dropdown list (. | Excel Discussion (Misc queries) | |||
Linear Mode
