VBA Advanced filter help..... Criteria excluding a list
Hi Team,
I Need your help in advanced filter, I have Data in Datasheet, and Criteria in Criteriasheet
In Criteria sheet.
I have 5 indian batsman list
and 5 Australian Batsman as Criteria list
I want to apply advanced filter on my data, I want to keep only 5 Indian Batsamns and 5 Australian Batsmans Record.
by removing unwanted data after advanced filter.
Attached is my input file and my attempted code which is not working, plz assist how to achieve this task and how to make dynamic list Thanks.
Regards,
mg
Last edited by malleshg24; 12-04-2019 at 01:45 PM.
Reason: Output sheet Added
Do you want to keep all instances of Australian batsman Ricky Pointing regardless of the Indian batsman?
It might be easier if you submit another file marking in column C the rows you want to keep.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
I have added output sheet after filtering manually the data,
if I come across any cell either Indian Batsman or Australian batsman,
from that Criteria Range, I will not delete those, Rest I will delete.