Trend in Excel

[smilelover]

Say for I have 1 to 10 for A1:A10,
now for B1 I have =A1,
B2 blank
B3 blank
B4 = A2
B5 blank
B6 Blank
and I want to continue this trend till B30,
what should I do
please reply asap, thank you very much

 

[Yahya]

try this code

Sub Test()
Dim c As Range
i = 1
For Each c In Range("a1:a10")
     Cells(i, 2).Formula = "=" & c.Address
     i = i + 3
Next c
End Sub

HTH