Macro only copies 1st row but...

[d_rose]

Hi, I have a macro that filters data by month from a worksheet labeled “2012 Statements.” It then finds and selects only the cells with data in them and copies that data to the appropriate months’ worksheet.
The problem I’m running into is:
For ANY month EXCEPT January the macro does exactly what it should do, BUT for January it ONLY copies the 1st row.
I’ve attached a small example of the Workbook along with the macro (which I’ve shortened so it only goes to February).
I’m hoping someone can help so the macro works correctly and also explain why it only copied the 1st row only for January.

Thanks in advance for any help

dave

[AB33]

this sheet is not attached

Please Login or Register  to view this content.

[d_rose]

My apologies, the original example was too large to upload, when I created the "Book2.xlsm" file I forgot to label the sheets correctly. I've now uploaded the workbook with the correct sheet names.