Need help with copy rows and insert code...

Hey everyone, I've got a spreadsheet that is layed out like this...

col1 col2 col3
row1 A 1 a1
row2 data data data
row3 data data data
row4 data data data
row5 A 2 a1
row6 A 3 a1
row7 B 1 a1

What I'm trying to do is set up a VBA code that will take lines lines 2-4, copy the rows and then paste them in new rows every other row for the rest of the document, so that it appears as...

col1 col2 col3
row1 A 1 a1
row2 data data data
row3 data data data
row4 data data data
row5 A 2 a1
row6 data data data
row7 data data data
row8 data data data
row9 A 3 a1
row10 data data data
row11 data data data
row12 data data data
row13 B 1 a1
row14 data data data
row15 data data data
row16 data data data

I hope this makes sense! It has been so long since I used VBA that I may have fried my brain tyring to figure this out. Thanks in advance!

try this:

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save