Use multiple cell values in autofilter criteria

**Dyordedgar** · 08-24-2016, 04:01 AM

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?

**zbor** · 08-24-2016, 04:03 AM

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.

**zbor** · 08-24-2016, 04:16 AM

Try this:

Please Login or Register  to view this content.

**bakerman2** · 08-24-2016, 04:21 AM

Or this.

Please Login or Register  to view this content.

**Dyordedgar** · 08-24-2016, 04:33 AM

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...

**bakerman2** · 08-24-2016, 04:58 AM

Maybe something like this.

Please Login or Register  to view this content.

**Dyordedgar** · 08-24-2016, 05:34 AM

Dank u wel / merci beaucoup bakerman2!

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

Any idea?

**bakerman2** · 08-24-2016, 10:41 AM

Hard to say without seeing example file to test on.

**Dyordedgar** · 08-26-2016, 08:10 AM

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!

**bakerman2** · 08-30-2016, 02:09 AM

Sorry for late response.
This works in your example file.

Please Login or Register  to view this content.

**Dyordedgar** · 08-31-2016, 08:29 AM

Hello Bakerman2!

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

**Dyordedgar** · 09-02-2016, 05:11 AM

Hello Bakerman2!

I replaced correctly your code and it works perfectly!

Thank you so much!

**bakerman2** · 09-02-2016, 09:50 AM

You're welcome.

Use multiple cell values in autofilter criteria

LinkBack

Thread Tools

Rate This Thread

Display

Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Re: Use multiple cell values in autofilter criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to return multiple values to a single cell based on multiple criteria

Autofilter multiple columns with multiple string criteria

VBA Autofilter multiple criteria

Aggregate multiple values into one cell based on multiple criteria using VBA

[SOLVED] Autofilter with multiple criteria - how to ignore blank criteria

Multiple Criteria for Autofilter using And & Or

multiple column , multiple criteria autofilter sort

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions