Dynamic Word List Generator

I have a database (see attached) of words (multiple columns, multiple sheets) and I'd like to create a vba code/macro that allows the user to input specific criteria (i.e. Starts with "p", Contains "u", Does not contain "x", etc.) to generate a list of words from the database that matches the criteria.

This will be a great tool for kindergarten teachers if I can make it work, but I have little excel experience. Any advice? Is this realistic?

You could just use excel's filter.

select 'text filters" and you can select something like 'does not contain' an then add "x" or just directly enter wildcards like "p*" (starts with p) in the filter and you can run multiple filters at the same time.

it doesn't sound like you need a custom macro.

See attached workbook. Below is code. Click the "Search" button on sheet1

Please Login or Register  to view this content.