I work in construction and am trying to get organized. I have several excel files for tracking documents, and want to create one file that shows me the documents not returned by other parties. My goal is that any row in the existing files that contains a specific phrase, i would like the entire row copied to the new file. I've seen other responses here that provide response to similar requests but i don't understand the response. What i'm looking for is step by step response, like "under the formulas tab, click "more functions" then select...." Plese help.

Thanks.