| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
I want to create two drop down boxes that are depending on each other.
For example I have a datasheet with fields like (customers,date,SKUs). I want to be able to create a drop down list based on Customer Name and another drop down based on SKU's. If I choose Customer A, the second drop down only allows the SKU's for that customer and vice versa, If I select a SKU, I only want Customers with that SKU in the other drop down list. Any help will be appreciated. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list
hi
what kind of drop down list???? combo box? data validation? assuming you are using DV, see this site... http://www.contextures.com/xlDataVal02.html http://www.contextures.on.ca/xlDataVal10.html regards FSt1 regards FSt1 "Sonny" wrote: I want to create two drop down boxes that are depending on each other. For example I have a datasheet with fields like (customers,date,SKUs). I want to be able to create a drop down list based on Customer Name and another drop down based on SKU's. If I choose Customer A, the second drop down only allows the SKU's for that customer and vice versa, If I select a SKU, I only want Customers with that SKU in the other drop down list. Any help will be appreciated. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
