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!
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?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks