I have two existing codes that:
1) Filters based on multiple criteria (keyed into 'Raw' tab, B3 to F3)
2) One of the criteria is a dropdown data validation list, which i have used a code to enable multiple selections (see attached file 'Raw' tab, cell D3)
The issue is that the filter does not work when D3 uses multiple criteria, as excel does not recognize the commas as separate criteria. Is there a way to modify my Filtering macro such that i can overcome this issue?
It's possible that I may be selecting multiple options in the D3 dropdown and not just 2 values.