Hi there, I have created an audit sheet and I need it to perfom an automatic task for me. Whenever the answer to a question is 'No' I want the entire row (containing question ID; Question; Reason for fail; required remedial actions etc.) to be copied onto a seperate worksheet, so that all the fails are collected on the same worksheet.

Any help you can give with this would be hugely appreciated. Thank you.