VBA To Delete Rows Based On Value Criteria In A Column

[jffryjsphbyn]

Hi there!

I would just like to ask if there is a way to delete a row which contains the word "Received" and "Pending" in column I? and transfer to another worksheet within a workbook whichh has the words "CA","US","ERROR","#VALUE!","XXX","YYY","VVV"? Please help!

Thank you in advance! :)

[Excel Fox]

Your first requirement is reasonably clear, although I'd still ask what do you mean by 'delete and transfer'. Does it mean to cut and paste? Or did you mean that you want to delete all rows that contain Received and Pending.

What's the second requirement? You mean you want to move all rows that have any one of the words "CA","US","ERROR","#VALUE!","XXX","YYY","VVV" to another worksheet in the same workbook?