Filter criteria based in column

Hi
I try filter, my criteria is in column (dinamic range), but doesn't work.
does not return all the values ​​that are in the column as a criterion.

Please Login or Register  to view this content.

Thank you!!

Hi Marreco,

This works with The ActiveCell as MyRng:

Please Login or Register  to view this content.

Hi, thanks, but i need filter all cells (simultaneously) in MyRng.

I don't understand - sorry old friend

Hi xladept, imagine that you have to filter, based on 60 criteria, at once.

thanks

Hi marreco -

can you upload the file with data and the macro and withOUT any company confidential data....

Hi, i doesn't understand...

Do you want withou macro?

no have problem with, company confidential data.

Sorry my Brasilian isn't very good

Could you please upload the file with the data and macro (example: .xlsm file)

also, please don't include any company confidential information (unless you don't have a problem with that)

sorry for the confusion...

I'm confuse becouse my file and macro it's #1 post

and you should be....My apologise for not reading the whole post....let me see what I can do

I'm not figuring this out....everything I try should work but doesn't....xladept should work...I looked up other techniques and they didn't work...I'm sorry but it looks like I'm not able to help....I can put this is another area and see if the gurus can help....

Hi.

I'm happy you try help, thank you!!

may be someone can help me.

hopefully somebody will....

hi, could someone help me?

Hi Marreco,

See if this works for you:

Please Login or Register  to view this content.

Hi old friend, you are great!!!!

I like it very much!!!

Thank you very very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

You're welcome, you're compliments have "made my day" - and, thanks for the rep!

Thanks xladept....you are more adept than I am.....thanks for helping....

@Ernest - thank you!