Link to home
Start Free TrialLog in
Avatar of easycapital
easycapitalFlag for Macao

asked on

Macro filter "and"

Criteria for macro:

1. multiple input cells (as attached, highlighted in yellow)
2. only SHOW rows which meet all of the criterias in the input cells
3. ignore input cells left blank

the user to input the info in the yellow highlighted cells and be able to input info in all yellow cells as I indicate and the macro to run in sheet 1 automatically to filter and show only the rows which meet all in the info entered.

Kind regards,
Juan
filter-columns.xls
SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi easycapital
Did you have a chance to try the proposed solution ?
gowflow
Avatar of easycapital

ASKER

Both answers work and resolved the question as possed.
Thanks Gowflow for the dynamic formula - it was great!
Thanks,
JP
Your welcomed glad we could help.
gowflow