Filter with three criteria

[S P P]

Boa noite!

Como filtrar os critérios B11 B13 B15

 

[vletm]

S P P
One basic way ...

 

[S P P]

vletm
Obrigado mais uma vez preciso do Vba que filtra e do Desfiltra

 

[vletm]

S P P
Se você precisa do VBA, pergunte no fórum de macros do VBA. Este é o fórum "Faça uma pergunta do Excel".
Por favor, da próxima vez use o inglês.

 

[vletm]

S P P
One sample ...

 

[Kevin@Radstock]

Hi

What version of excel are you using, if you have 365 or 2019, take advantage of DA's

=FILTER(B1730,(H17:H30=B11)*(F17:F30=B13)*(I17:I30=B15),"") format "General;;"

or for 4 columns

=FILTER(CHOOSE({1,2,3,4},C17:C30,F17:F30,H17:H30,I17:I30),(H17:H30=B11)*(F17:F30=B13)*(I17:I30=B15))

 

[S P P]

vletm
Good Morning!

Removing the filter
how to use this example VisibleDropDown: = False

 

[vletm]

S P P
I'm using my file ...
What do You expect to remove?
If no need those 'filter dropdown's then ... something like this?

 

[S P P]

vletm
When selecting another value

Error 438

 

[S P P]

Removing the filter

 

[S P P]

Your file
when selecting another value

Error 438

 

[vletm]

S P P
As I wrote in #10
What did You select?
I tested to select each of those three possibilities without error.
If I cannot get needed details ... I cannot help.

 

[S P P]

I'm sending you the spreadsheet I downloaded that is giving error

 

[vletm]

@S P P
That file works with me.
Still You could not write answer, which I have asked few times ...
What did You select?
I tested to select each of those three possibilities without error.
If I cannot get needed details ... I cannot help.
You could hide that .ShowAutoFilterDropDown = False line
and see will it change something for You.

 

[S P P]

I don't understand this spreadsheet that I sent you
if month or code change displays ERROR 438

 

[vletm]

S P P
Finally You could answer ...
but ...
If I activate cell B12 and select from dropdown any month (1-12) - here it works.
If I do same tests with cell B14-dropdown - here it works.
> Did You test to hide that line ... as I asked?
S P P
Seems You skipped above question too ...

 

[S P P]

vletm

Thanks for the help and time available