| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop-down list & auto-population of cells
Hi,
I am trying to create a form where a user would select from a list of different products. Depending on the users product selection, certain other information may need to be populated. How can I make it so the drop-down list auto populates other cells (i.e. customer name field, location, etc.) after certain products are selected. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop-down list & auto-population of cells
Try Debra's "Create an Order Form" example at her:
http://www.contextures.com/xlOrderForm01.html which covers what you're after (DV & Vlookup to populate) (There's also a sample file to download) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "TC" wrote in message ... Hi, I am trying to create a form where a user would select from a list of different products. Depending on the users product selection, certain other information may need to be populated. How can I make it so the drop-down list auto populates other cells (i.e. customer name field, location, etc.) after certain products are selected. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop-down list & auto-population of cells
Great info.. Thank you so much!
"Max" wrote: Try Debra's "Create an Order Form" example at her: http://www.contextures.com/xlOrderForm01.html which covers what you're after (DV & Vlookup to populate) (There's also a sample file to download) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "TC" wrote in message ... Hi, I am trying to create a form where a user would select from a list of different products. Depending on the users product selection, certain other information may need to be populated. How can I make it so the drop-down list auto populates other cells (i.e. customer name field, location, etc.) after certain products are selected. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop-down list & auto-population of cells
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "TC" wrote in message ... Great info.. Thank you so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| No drop down list type-ahead? | Excel Discussion (Misc queries) | |||
| How do I delete a drop list button | Excel Worksheet Functions | |||
| select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
| Drop Down List | Excel Worksheet Functions | |||
Linear Mode
