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
Bookmarks