Hello Mrexcel experts,
Greetings!
I am a beginner in excel vba. I have 3 headers in my file with lots of similar contents (Words) under column. I have allowed user to mention the filter criteria for each header (upto 5 criteria) in a separate sheet . I would like to have a excel vba code for this.
Eg:
columns A B C;
Column A has Red yellow blue green Orange pink purple - the user chooses to have Pink and Purple and leaves the other critera cells blank.
Column B: has 1, 2, 3, 4, 5 - User chooses 5 only and leaves the other criteria cells blank.
Column C: User does not choose anything and leave all the 5 cells blanks.
Macro needs to check this creterias filled and implement the filter automatically to my data.
Pls support with excel vBA codes for this.
Greetings!
I am a beginner in excel vba. I have 3 headers in my file with lots of similar contents (Words) under column. I have allowed user to mention the filter criteria for each header (upto 5 criteria) in a separate sheet . I would like to have a excel vba code for this.
Eg:
columns A B C;
Column A has Red yellow blue green Orange pink purple - the user chooses to have Pink and Purple and leaves the other critera cells blank.
Column B: has 1, 2, 3, 4, 5 - User chooses 5 only and leaves the other criteria cells blank.
Column C: User does not choose anything and leave all the 5 cells blanks.
Macro needs to check this creterias filled and implement the filter automatically to my data.
Pls support with excel vBA codes for this.
