I need to insert a blank row after every third row of data in excel 2007, it is
ID: 3563239 • Letter: I
Question
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!!@
Explanation / Answer
Hi,
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.
.....................................