Filter Results, paste visible results of certain cells in the row into another worksheet

Screenshot.docx

Hi,
I hope someone can help and if they do I'll be eternally grateful because I'm losing the will to live!!

Please see attached screenshot of my spreadsheet the range of the data is B12 :O122

What I need to do is to filter Column K (Starting at K13) with criteria "NO" and copy the contents of certain cells in the row into another worksheet.
Using Row K13 as an example, If the criteria meets NO I would like the contents of cells B13, C13, G13, I13, K13, M13, N13 and O13 to be copied into the 'Report' worksheet starting in Cell B27. I'd like it to do this from K13 to K122 and copy the contents as above.
Then I'd like to do the same using criteria "YES" but paste in the next available row with 1 row separating the results of NO and again using criteria N/A.
I'd like only visible cells to be pasted.

I can't fathom it out and I've been trying for days!! Any help would be very, very much appreciated,
Many thanks in advance

Hi,
Thank you for replying, it's greatly appreciated.
Please find attached a copy of my file and if it's not there please could you let me know because
I've had trouble uploading it!

Many thanks

I forgot to mention that this template will be used in different circumstances which means the range for the criteria's will be different for each audit eg. one audit there may be 13 NO's but in another there may only be 3 NO's, Is it possible to factor that in?
Thanks again