Seamus2626
asked on
Like Autofilter
Hi,
I have some code that filters out anything like "Bulk Upload" and deletes the lines
The problem is i have entries coming through that i need to keep - namely
"PCM ASP BB Clients Bulk Upload"
So all the other lines that contain Bulk Upload need to be deleted but the above needs to stay.
Can i say delete anything that is like "Bulk upload" except
"PCM ASP BB Clients Bulk Upload"
Many thanks!
I have some code that filters out anything like "Bulk Upload" and deletes the lines
ActiveSheet.Range("A1:Q1").AutoFilter
ActiveSheet.Range(Range("A1"), Range("C" & Rows.Count).End(xlUp)).AutoFilter Field:=3, _
Criteria1:=Array("*Bulk Upload*"), Operator:=xlFilterValues
ActiveSheet.Range(Range("C2"), Range("C" & Rows.Count).End(xlUp)).SpecialCells(xlVisible).EntireRow.Delete Shift:=xlUp
ActiveSheet.Range("A1:Q1").AutoFilter
The problem is i have entries coming through that i need to keep - namely
"PCM ASP BB Clients Bulk Upload"
So all the other lines that contain Bulk Upload need to be deleted but the above needs to stay.
Can i say delete anything that is like "Bulk upload" except
"PCM ASP BB Clients Bulk Upload"
Many thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.