VBA Multiple Filtering (Large Data)

[Kalaiselvan]

1	Product ( example Nescafe, Dolce Gusto Machines, Nesle Bliss)- Indicate the main products
2	Product Name List - eg: bliss orange, Bliss apple
3	The selected product Name will appear with the indication "malaysian" or " Imported"
4	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
	" 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.

<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>

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....