ali.b
2014/06/06, 10:21
Sub StaggerCopy()Dim i As Long, c As Long
c = 4
For i = 8 To 41
Sheets("Sheet1").Range(Cells(3, i), Cells(143, i)).Copy _
Sheets("Sheet2").Cells(4, c)
c = c + 5
Next i
End Sub
c = 4
For i = 8 To 41
Sheets("Sheet1").Range(Cells(3, i), Cells(143, i)).Copy _
Sheets("Sheet2").Cells(4, c)
c = c + 5
Next i
End Sub