I hope that title made sense. This is my first time posting on this forum, so let me apologize in advance if this thread is in the wrong place.

Basically, I have a excel sheet that I'm using to audit something. I have rows of data with one column on the very right that I use to input the results of my audit (yes, no or n/a). What I'd like to do is have each row with the "no" response appear on another sheet so I have a collection of all rows that contain the "no" response.

I tried using the filter tool but there are few things that make it inadequate for what I'm trying to do.

1. I need this process to be fairly easy for other (non-technical) people to execute.

2. I need it to be automated in the interest of saving time.

3. Another reason I'm trying to avoid the filter tool is because I don't want anyone applying tools to the data directly. This could result someone to accidentally or unknowingly alter the data.

I would really appreciate any suggestions as I have racked my brain for quite a while and I have a feeling that someone on this forum probably already has the answer.

Thank you in advance!

Jeh