macro help with Data list sorted by date then add a month Heading in between the sections

Hi-
I am stuck and hoping someone can help. I have a list of data that is sorted by months. I want it broken down into quarters so only 3 months show at a time. I have that part worked out. I have Jan-Mar data listed. I also have the space between months worked out. What I need help with is inserting a monthly heading above each section. The monthly heading is contained on the same sheet in cells AJ7, AJ8, AJ9 using a formula, based on the user selection. Above Row 1 copy cell value AJ7 contains (January), insert at row 5 value AJ8 (February), insert at row 11 value AJ9 (March). However, the number of rows in each monthly section will vary

My data looks like

Row 1 Col C:K Data with date Jan
Row 2 Col C:K Data with date Jan
Row 3 Col C:K Data with date Jan
Row 4 Col C:K blank
Row 5 Col C:K blank
Row 6 Col C:K Data with date Feb
Row 7 Col C:K Data with date Feb
Row 8 Col C:K Data with date Feb
Row 9 Col C:K Data with date Feb
Row 10 Col C:K blank
Row 11 Col C:K blank
Row 12 Col C:K Data with date Mar
Row 13 Col C:K Data with date Mar

If there is another way to achieve this without using my code or re-writing it that's OK. I know where the code needs to go, but can't figure out what the code should be to achieve my needs

Please Login or Register  to view this content.

Bump...anyone can help/give guidance?