Autofilling rows into new tab based on multiple criteria

[excelplshelp]

Hi there,

I was trying to search through old forums and am really close to getting the answer I need but haven't quite found the perfect solution and am now turning here for help. I have column C in sheet 1 that currently populates only if somewhere in that row has the word "fail" or "hold". Column C is blank otherwise, but if anywhere in the row "fail" or "hold" occurs, Column C will also say "fail" or "hold".

I know there is a way to autopopulate another tab will only the rows that contain "fail" or "hold" based on column C, all at the top stacked neatly underneath each other in sheet 2. I would love the formula for this. Can anyone help?

 

[alansidman]

On the Ribbon, Data Tab, Advanced Filter.

http://www.contextures.com/xladvfilter01.html