Hi,
This is the method in which we use the autofilter according to Excel’s VBA help: expression.AutoFilter(Field, Criteria1, Operator, Criteria2, VisibleDropDown).
I have a sheet in which I want to filter my accounts that are in range “G:G” according to the criteria that are put in range “P:P” as is shown below:
Criteria:
Banks
Customers
Sells
.....
How should I use the above code? What is “expression”? What is “Field” ( is it a range)?
This is the method in which we use the autofilter according to Excel’s VBA help: expression.AutoFilter(Field, Criteria1, Operator, Criteria2, VisibleDropDown).
I have a sheet in which I want to filter my accounts that are in range “G:G” according to the criteria that are put in range “P:P” as is shown below:
Criteria:
Banks
Customers
Sells
.....
How should I use the above code? What is “expression”? What is “Field” ( is it a range)?