Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bringing additional information in with combo box selection
I have looked at several methods but want the cleanest (easiest) way to bring
data from another worksheet in the same workbook based on a user selection from a combo box. Combo Box to show customer name (I can do this) but would like to automatically fill anothor cell with related data (customer's discount) from a table not seen by user. |
#2
|
|||
|
|||
You can use Data Validation to create dropdown lists. There are instructions
in Excel's help, and he http://www.contextures.com/xlDataVal01.html To return the discount for the selected customer, you can use a VLookup formula. There are instructions and examples he http://www.contextures.com/xlFunctions02.html There's a sample file that uses Data Validation and VLookup formulas he http://www.contextures.com/excelfiles.html#Function Under Data Validation, look for 'Order Form' "JD" wrote: I have looked at several methods but want the cleanest (easiest) way to bring data from another worksheet in the same workbook based on a user selection from a combo box. Combo Box to show customer name (I can do this) but would like to automatically fill anothor cell with related data (customer's discount) from a table not seen by user. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract data from combo box n use it in SQL | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions |