Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronise 2 dropdowns
My spreadsheet has two drop down boxes in 2 different
columns. For example, the first drop down box will list all of my companies products types. The second drop down box has a list of product variations. I would like to set the spreadsheet up so once a product is selected in the first drop down box the second drop down box only displays the variations of that particular product and not variations for all products. Basically I'd like to filter the data as each drop down box is used. Is this possible? Or, will i have to make combos. How shud i do it? Please help. Thanks Ashu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronise 2 dropdowns
Hi
see: http://www.contextures.com/xlDataVal02.html and http://www.xldynamic.com/source/xld.Dropdowns.html -----Original Message----- My spreadsheet has two drop down boxes in 2 different columns. For example, the first drop down box will list all of my companies products types. The second drop down box has a list of product variations. I would like to set the spreadsheet up so once a product is selected in the first drop down box the second drop down box only displays the variations of that particular product and not variations for all products. Basically I'd like to filter the data as each drop down box is used. Is this possible? Or, will i have to make combos. How shud i do it? Please help. Thanks Ashu . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I synchronise Excel files ? | Excel Discussion (Misc queries) | |||
using dropdowns | Excel Discussion (Misc queries) | |||
How to sort/synchronise 2 data columns with missing records? | Excel Discussion (Misc queries) | |||
How can i synchronise worksheets in 2 different excel file... | Excel Discussion (Misc queries) | |||
DropDowns | Excel Discussion (Misc queries) |