How To Insert A Row After Specific Criteria

[PaddyP]

Hello,

I have a long list of dates. I need to insert two rows below each new date. Any shortcuts on how to do this.

Sheet 1 is a small portion of my data. Sheet 2 is how I want the data to look.

Thank you!

[Logit]

.
You can use a loop within a macro :

Please Login or Register  to view this content.

[Logit]

.
To insert TWO BLANK ROWS ...

Please Login or Register  to view this content.

[PaddyP]

Thank you. I will give this a shot.