Formula needed to identify unique string then capture the entire row it appears in

So I have a spreadsheet that contains the string N/A in multiple cells. This string signifies data that is missing and will eventually need to be populated. How can I search for each instance of "N/A" then capture the entire row that it appears in and copy it somewhere?

Ideally, I'd like to copy each row that contains "N/A" to a separate workbook. Any guidance would be most appreciated.

Thanks.

Originally Posted by TMShucks

Use Autofilter to filter for NA

Thank you for the suggestion, makes perfect sense. I've never used Autofilter before but it seems straightforward enough.

Just highlight an "#N/A", hit Autofilter, then bam! Only rows containing "#N/A" are displayed. Is that how its supposed to work? Almost seems too easy!

Thanks again.