excel macro copy/paste to new sheet, next row

A little background, I've got an excel spreadsheet that gets updated everyday. If there are no problems at the facility, there is nothing to paste to the other worksheet. I just need to record problems at the facility on to another worksheet. I could do it by date, but I would have big blank areas on the sheet because we only have problems a couple times a month. This spreadsheet captures a years worth of operational data.

here's what I've got so far, it may not be pretty but it works (except for the part in bold that I need to paste to the next row)



I need to start @ B40 and each time there is something in M13 (and sum J37 > 0) it needs to past to B41, then the next time B42.

I hope this makes sense!
thanks!
...Brady

If you're asking what I think you're asking, then this is a relatively easy problem to solve. I wrote an excel macro for a friend at work that involved something similar. What you have to do is use a static column index (pick a column that will always have a value in it if records are present), and a variable row index to loop through the records in your excel table. Use a simple comparison to determine if the field value is = " " or not, and if it is, then insert your new row using your row variable's value.