Autofill

S

samsg

Hi, i have a list of values like this:

54
24
31
...

I want to place number 54 and then leave 4 blank spaces, the plac
number 24, and 4 blanks, and so on, so it would look like this

54


24


31
...

How can i do this automatically?, the list is too long to insert
cells and then press f4 for each value, is there an autofill that ca
skip rows , or something that can help me??

Thanks a lot for the hel
 
D

Dave Peterson

blank rows?

If yes, you could run a little macro:

Option Explicit
Sub testme()

Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long

With ActiveSheet
FirstRow = 1
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For iRow = LastRow To FirstRow + 1 Step -1
.Rows(iRow).Resize(4).Insert
Next iRow
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top