Join 3,415 readers in helping fund MetaFilter (Hide)


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.
posted by undercoverhuwaaah to Computers & Internet (2 answers total) 1 user marked this as a favorite
 
yes. Using named ranges

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


Found my answer here. D'oh.
posted by undercoverhuwaaah at 8:41 AM on August 15, 2012


« Older Document Scanning -- I have a ...   |  How do you reconcile end-of-li... Newer »
This thread is closed to new comments.