How to insert rows after every third row of data in excel(800 rows)? I need to i

ID: 3562838 • Letter: H

Question

How to insert rows after every third row of data in excel(800 rows)?

I need to insert a blank row after every third row of data in excel 2007, it is a constant periodic insertion, so is there a formula?

Example;

Brusters Old Fshoned Ice Cream

101 Riverwalk CT

Canton, GA 30114-3665

Mother Dairies

101 Riverwalk CT

Canton, GA 30114-3665

Allied Computer Systems Inc

224 Brown Industrial Pkwy

Canton, GA 30114-8064

Absolute Elegance Limousine

224 Brown Industrial Pkwy

Canton, GA 30114-8064

Ameritech Services Inc

224 Brown Industrial Pkwy

Canton, GA 30114-8064

This is all in column A.

Thank you

i assume that your data are from row1 up to row??
try this code..

Sub abc()
t = 4
Do Until Cells(t, "A") = ""
Rows(t).Insert
t = t + 4
Loop
End Sub

.....................................................

press ALT+F11 to open VB editor.

Insert > module and paste the code above on the right

Close VB editor.

....................................

To run the macro, press ALT+F8,

select <abc> from the list and click the run button.

.....................................

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.