VBA Filter: filter with keywords and attributes

[moosmahna]

Hy,

I need a filter with VBA. I searched a lot in the forum and in the internet but I had no luck finding a macro that I need.
In my worksheet I have a string. The macro should look if there are one or more keywords in the string. If there is one ore more, then filter the list "data" with the keywords.
After that the macro should search the filtered results if there are attributes in the results and filter it again.

I uploaded a worksheet with explanations. I hope you can help me.

Thanks to everyone
Kind Regards
Roman

[karedog]

Maybe :

Please Login or Register  to view this content.

[moosmahna]

Hi karedog

thanks a lot for your code. I have tested it and it works really great!!!!
But when I expand the list with the keywords and the list with data with new entries, then there is nothing found...
Kind Regards
Roman

[karedog]

Please upload your workbook with these "keywords and new entries" addition that not worked.

[moosmahna]

I found the error. The keyword must have an attribute.
Can you please modify the code that results with only one or more keyword(s) and no matching attributes is also listed?
THNAK YOU

[moosmahna]

And there are no results when the attributes are like "50 mm" or just "50"...

[karedog]

I found the error. The keyword must have an attribute.

But this is what you describe in your first file :
Description on cell D16 : "search the string if there are attributes in the results after searching for keywords"
And in your example, your manual output is B20:E22, you remove B11:E11 because it has no attributes expected (sweet white)

---------------------

Here I make 2 separate subs, one is checking the keyword only, the other one is for checking with attributes

Please Login or Register  to view this content.

[moosmahna]

Hi karedog,

I have tested your new macros, but I got no results...

[moosmahna]

Sorry, it works!!! I have forgotten to save the file.

It works really great. Thanks again. But can you help me modify the code, that the macro takes the string and searches if it contains values from the data-table?
No need of keywords. I found out, that in my list are too many keywords and some of them are written wrong.

THANK YOU AGAIN!!!

[karedog]

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[moosmahna]

Hy karedog.

THANK YOU VERY VERY MUCH!!!! THATS PERFECT!!!

Kind Regards
Roman

[karedog]

You are welcome, glad to help.

Regards