Use multiple cell values in autofilter criteria

Good Morning!

I'm trying to make a macro filter, but I don't know how to use multiple cells as criteria.

I'm using this:

Please Login or Register  to view this content.

But the filter is using only the value in K3.

Can anyone help me please?

Plese use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting and make different than other text.

Highlight your code and click the # icon at the top of your post window.

I've fix it now for you.

Try this:

Please Login or Register  to view this content.

Thanks for your help zbor and bakerman2!

I forgot to tell this:
The cells I want to use as criteria are in Sheet4, and the table is in Sheet3.

Let me show you all the code:

Please Login or Register  to view this content.

I don't know how to mix your code with mine...

Dank u wel / merci beaucoup bakerman2!

I placed your macro but it shows me this error:
"Type mismatch"

Any idea?

Hello Bakerman2

I've upload a very simple exemple to make you know what I want.

The result I am searching for is the one you can see in Sheet2

Thanks in advance for your help!

Hello Bakerman2!

Thanks for your help!
I need to replace your code with mine and see how can it work.

Hello Bakerman2!

I replaced correctly your code and it works perfectly!

Thank you so much!