Auto Copy based on Condition

Tara - Nov 13, 2015 at 10:10 AM

I have developed an Auditing sheet in Excel in which the results are copied into a Word document to create an audit summary report. How do I get excel to copy all the rows that contain the word "missing" and paste them collectively within the spreadsheet OR directly into my Summary report in Word?