Advanced Filter Data And Pick Up Criteria From cells

[dave_100]

Hi guys
I'm trying to run an advanced filter. My macro I recorded below is done by manually typing in "ipad" and "case" in the advanced filter section, to filter all results that CONTAIN those 2 words, however, there are other times I need to run the macro, and it filter out different words (again, that contains these 2 words), I would like those words to be from a cell I specify (eg L1 and M1).

I've tried substituting "ipad" and "case" in the code to "L1" and "M1" in brackets, and speech marks, but nothing is working so far.

please can someone help?

Please Login or Register  to view this content.

[watersev]

hi dave_100, welcome to Excelforum,

Please Login or Register  to view this content.

[dave_100]

Wow thank you! that is such a powerful tool. It works spot on. I would love to understand the logic behind it so I can understand how the code is written, is it even worth me asking, or do you just know the code from experience and trial and error?

[watersev]

variable enclosed with & will be replaced with its value. Without & variable will be considered as a simple string

[dave_100]

on a similar note how would I make the below number filter only give results greater than whatever is in cell I1, rather than as it is, which is greater than 200?

Please Login or Register  to view this content.

[watersev]

Please Login or Register  to view this content.