Excel Filter drill down

[Nagoo]

Good morning,

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.

Thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1071910-filter-doubts.html#post5148775

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).