VBA Multiple Filtering (Large Data)

[Kalaiselvan]

[TABLE="width: 714"]
<colgroup><col><col><col span="8"></colgroup><tbody>[TR]
[TD]1[/TD]
[TD="colspan: 8"]Product ( example Nescafe, Dolce Gusto Machines, Nesle Bliss)- Indicate the main products[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Product Name List - eg: bliss orange, Bliss apple[/TD]
[TD="colspan: 8"][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="colspan: 8"]The selected product Name will appear with the indication "malaysian" or " Imported"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="colspan: 9"]Choose state ( once choose the state , hence it will indicate the the Sales Manager we need to refer to, COE1, COE 2 ,QA Manager 1, QA Manager 2, QA exec1,QA Exec2,QA Exec 3, QA Exec 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]" please take note that certain region only consist 1 QA manager and Qa exec varies from 2 to 4 QA's, it consist of the name and email address. so we able to copy the details and email to the right person.[/TD]
[/TR]
</tbody>[/TABLE]

https://drive.google.com/file/d/179b6g-OfdSPglLov1qrfPWPJCqY89kIW/view?usp=sharing

i have shared via google drive, really appreciate your help on this since im new with VBA and coding

 

[Kalaiselvan]

Re: Need Help - VBA Multiple Filtering (Large Data)

Im sharing more clearer version what i needed. please assist

https://drive.google.com/file/d/1fxaYrNGkJxRGcZ7Cfaf1_kKs6b3MhDZk/view?usp=sharing

 

[Kalaiselvan]

Re: Need Help - VBA Multiple Filtering (Large Data)

please assist to help me on this.

 

[Kalaiselvan]

Re: Need Help - VBA Multiple Filtering (Large Data)

Can you help where went wrong?

https://drive.google.com/file/d/1JGSDvtZvcJvFYVvTXvHOyo-rEo0nfgAI/view?usp=sharing

this is my worksheet...
i tried to do the filtering based on this video clip, please assist me, urgently need this.

http://www.onlinepclearning.com/excel-advanced-filter-multiple-criteria/

 

[Kalaiselvan]

Re: Need Help - VBA Multiple Filtering (Large Data)

Can any good soul help me on this....