I have a file with two spread sheets used for First Article Inspection/ First
Article Reports. I am trying to automatically load data from the inspection
sheet to the report if the results of the inspection were out of tolerance.
In other words, if a particlular cell is anything but an empty string, I want
to move the data from that row to the second sheet. The following is an
attempted formula for just one of the cells in the row on the report sheet.

=IF(FAIR!M6:N6="","",FAIR!A6)

"FAIR" is the First Arctilce Inspection Sheet.

Can anyone guide me in completing this task