hello,

I have a situation where i need to copy all line items with the word "approved" in a certain column to a new worksheet so that only approved items will be at the new sheet. can you please advise on how to get this done?

thanks in advance