Formula needed to identify unique string then copy the row it appears in to another workbook.

[66mhz]

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.

 

[66mhz]

I'm also looking into the possibility of using a macro to accomplish what I described above but have been unsuccessful thus far.

 

[66mhz]

So I used Autofilter to identify all the instances of '#N/A'. I then copied those rows out to their new home.

Any thoughts on this method? It seems to have worked fine. Always willing to hear other points of view.