ExcelBanter - Copy row to worksheet IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy row to worksheet IF (https://www.excelbanter.com/excel-programming/441669-copy-row-worksheet-if.html)

Kcope8302

Copy row to worksheet IF

I have a worksheet that I call data. I paste a set of data into this
worksheet and I want certain rows(A:G) to be copied to another worksheet
(Status) if Column B states Failed, Not Completed or No run.

All times are GMT +1. The time now is 11:33 AM.