I don’t know what to call this feature, but I was wondering if there was a way to control the listed items in a category drop down by creating a dependency on another category.
For instance, the contents of one categroy drop down would be filtered based on the selected category from another drop down.
Does that make sense?
Yes – If you right click on a cell, choose Constrain Input. Then choose ‘Category Item Names’ and pick the category you want to base the list on. Then any additions, modifications or deletions to this category will show up on the list.
Hope this helps. Feel free to post again with any additional questions.