VBA Autofilter\Advanced Filter

[Mallesh23]

Hi Team,

Below is my Criteria list , I want to apply Auto filter on my data,
Can Autofilter works here ?...needs to apply Criteria for 4 Columns here.

if Autofilter can't apply then How to arrange Criteria list for advanced Filter.

please assist thanks for your help in advance !

Criteria List

Product	Status	Account Name	Fund Name
Generic	In Progress	ABC	123
Structure		PQR	789
		XYZ	456
			321

Regards,
mg

 

[Zack Barresse]

Use AdvancedFilter.

An intro: Excel Advanced Filter Introduction