Validating data for data validation.
August 15, 2012 8:26 AM Subscribe
[ExcelFilter] Can I use one data validation list drop-down menu to specify which values will show up in a separate data validation list drop-down menu?
I have a long list of products. These can be grouped into a shorter list of product categories. I need users of a worksheet to pick a product from a drop-down menu. For ease of use, I would like them to be able to pick a product category in one drop-down menu, then have only the specific products in that category show up in a second drop-down menu. Setting up data validation drop down lists does not allow for inserting formulas in the "Source" area. Is this possible without getting too code-y? I'm not well versed in the VBA side of things. I would even settle for a list that would show product category, then some sort of indented list of accounts in the same data validation drop-down.
I have a long list of products. These can be grouped into a shorter list of product categories. I need users of a worksheet to pick a product from a drop-down menu. For ease of use, I would like them to be able to pick a product category in one drop-down menu, then have only the specific products in that category show up in a second drop-down menu. Setting up data validation drop down lists does not allow for inserting formulas in the "Source" area. Is this possible without getting too code-y? I'm not well versed in the VBA side of things. I would even settle for a list that would show product category, then some sort of indented list of accounts in the same data validation drop-down.
« Older Wondering if a new S1500 scanner is worth the... | To resuscitate or not to resuscitate Newer »
This thread is closed to new comments.
Where the named range is a bunch of if statements, and the dependent data validation list is made up of that named range
That said I would add a field to your data and then you use a pivot table.
posted by JPD at 8:32 AM on August 15, 2012