vba code for deleting rows upon find texts in multiple columns

[Dinesh_Excel]

Hi Team,

I tend to copy data to a sheet from a tool and then will filter column B search for text containing - Invoice ", " Payment" and PO and delete the entire rows ..similarly unfilter and then filter again Column C contains text :. "Germany" , "Poland" and UK.....this continues till as I have mentioned in the above threads.

Column B contains text : "Invoice ", " Payment" and PO

Column C contains text : "Germany" , "Poland" and UK

Column D contains text : " Paid" ," outstanding" and Overdue

Column E contains text : " Scope" ,"not in scope"


The rows should be deleted upon satisfying the above criteria.
Please help me on extending the below code
After which I have the remaining Data which is used for reporting

 

[Marc L]

Hi !

Use a filter on each column …
​

 

[Dinesh_Excel]

Thank you Marc....Appreciate your help