Auto Filter by Macro

Hi all,

I tried to find something for the problem I have that I'm going to explain you but really I don't have so much time to do this.. that's why I'm posting this request that maybe you already listened to a lot of times... sorry about that!

So my question is:

I have in Column1 hundred tasks and in the next Column2 I have the persons assigned to every task. So some tasks are assigned for instance to Person1, others to Person2, others to Person3 and so on, others to Person1 & Person2, others to Person1 & Person2 & Person3, others to Person2 & Person3, and so on...I mean every kind of possibilities.

So what I'd like to do is building a Macro that allows me to Filter for Instance all the Tasks assigned to Person1. The issue is that by the Auto Filter of Excel I can filter just the tasks assigned to ONLY Person1 but what I want is filter ALL the Tasks assigned at least to Person1, but could be even to Person2.
So I want to display all the tasks assigned to Person1 and that means that I want to obtain the Tasks assigned to Person1, Person1 & Person2, Person1 & Person3, Person1 & Person2 & Person3, and so on...In other words I want to filter the Tasks with the Criteria that all the rows/cells in the Column2 have the word "Person1".

Hope the question is clear and that you have the answer... I will really appreciate your help.

Thanks a lot in advance.

Nino

Originally Posted by mrice

Have you tried using the custom option in auto-filter using the 'contains' criteria?

Yes I know that with the custom auto-filter it works, but the issue is having a button (Macro) that does exactly the 'contains' criteria.
If you know by any chance the Visual Basic code to build the Macro you save me.

Thank you again

Nino

Originally Posted by mudraker

Have you tried recording a macro whilst applying the custom autofilter?

No, actually I don't know how to do what you said..

I hoped somebody posted just the code, that did what I explained above, to paste in Visual Basic Editor to record then the Macro.. Unfortunately I don't have the programming knowledge to compile the script.

Thank you..

I think I learned something new about Macro now!

I mean you don't need to be able to compile the script in VisualBasic..for my case...it's not necessary

God Bless you

bye

nino