Multiple keyword in a single cell. Possible to filter words separately in dropdown menu?

You will need VBA for enable multiple keyword selection.

This is confusing since you talk of check boxes and a data validation drop down.

The B14 validation drop down can only show one item. If keyword 1 is picked I can see how you want rows 1 2 & 5. But if keyword 3 is picked you'd only see row 2.

You need to clarify

It seems to ne you'd be better creating a complete set of data with row 1 appearing three times with keywords 1, 2 5 in the adjacent column. Ditto row 2 appearing twice with keyword 1 & 3 ...etc

Originally Posted by Richard Buttrey

This is confusing since you talk of check boxes and a data validation drop down.

The B14 validation drop down can only show one item. If keyword 1 is picked I can see how you want rows 1 2 & 5. But if keyword 3 is picked you'd only see row 2.

You need to clarify

It seems to ne you'd be better creating a complete set of data with row 1 appearing three times with keywords 1, 2 5 in the adjacent column. Ditto row 2 appearing twice with keyword 1 & 3 ...etc

Sorry for not being clear enough.

Then let us start with picking only one keyword via validation drop and the result should be just the rows containing that keyword. And I can't just let the rows reappear, as external users have to use the table. Could you alter the table I uploaded to give an example how this would work?

Thanks.

Originally Posted by JohnTopley

You will need VBA for enable multiple keyword selection.

Ok, thx for clarifying.

Code for multi-selection in dropdown

Please Login or Register  to view this content.

Code to get output

Please Login or Register  to view this content.

Highlighted areas are named ranges which need adjusting to fit your actual w/book

As entries are added in drop-down the output rows are updated.

Clear C14 then select data

It isn't in the code: it is in Data Validation>>Allow: List Source: =Keywords (named range).

Thanks again!

Would it be possible
- to write the output to a new worksheet
- or (that would be best) to just fade out the rows not containing the keywords in the original data table (rows 5-9). E.g. choosing keyword 1 would fade out row 7 and 8, when you delete the input in C14 all rows would be displayed again.

(and where in the code it is defined where the output is written, and how to change that)