I have a table of recipes:
Dish | Ingredients | Tools |
Soup |tomatoes, basil|bowl, fork |
Pizza|eggs, cheese |pan, knife, plate|
Pie |meat, eggs, ham|skillet, knife |
If I activate the filter for column header 'Ingredients', I can only filter whole cell contents:
tomatoes, basil
eggs, cheese
meat, eggs, ham
However, what I want is to be able to select all individual "tokens" from all cells as in:
tomatoes
basil
eggs
cheese
meat
ham
Any idea on how to accomplish this? I assume I will need to do some VBA coding to "inject" these tokens into the filter selection list?