Rayne
asked on
Conditional Drop downs Really
Hello All,
There are two data validation dropdowns. There is category and a iten belongs to the category. Now needed is a worksheet change event that triggers this:
If the user selects a category, then first it looks at the numbers of the items that lie in that category range, if the number of items in that category range is more than one, the second dropdown shows “ALL “ by default.
On the other hand, if the category range has only one item in the list, then it shows that one item for the itemChoice range by default
For example: If I select category 1, I get to see “ALL” by default for the item dropdown. If I select category2, then item dropdown gets the first item [a2] shown in the item choice dropdown
prefill.xlsm
There are two data validation dropdowns. There is category and a iten belongs to the category. Now needed is a worksheet change event that triggers this:
If the user selects a category, then first it looks at the numbers of the items that lie in that category range, if the number of items in that category range is more than one, the second dropdown shows “ALL “ by default.
On the other hand, if the category range has only one item in the list, then it shows that one item for the itemChoice range by default
For example: If I select category 1, I get to see “ALL” by default for the item dropdown. If I select category2, then item dropdown gets the first item [a2] shown in the item choice dropdown
prefill.xlsm
ASKER
Getting errors when I select category 1 and others
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfection is what I got. Thank you Imnorie :)
ASKER
Thank you