I'm not sure how to search for this, if it's already been answered:
I have 2 adjacent cells, each with a unique drop-down list. If I pick something from the first list, I want the options for the second cell list to be limited by the first choice. For example, if the choices for the first list are "fruit" or "veg", and I choose "veg", then the choices available in the second cell would only be in the veg category. But if I chose "fruit" for the first cell, no veg options would be in the list for the second cell (only fruit). Does that make any sense?
I have 2 adjacent cells, each with a unique drop-down list. If I pick something from the first list, I want the options for the second cell list to be limited by the first choice. For example, if the choices for the first list are "fruit" or "veg", and I choose "veg", then the choices available in the second cell would only be in the veg category. But if I chose "fruit" for the first cell, no veg options would be in the list for the second cell (only fruit). Does that make any sense?