Ethan
04-23-2015, 03:06 AM
The following code populates range A10 to A100 with data from range F10:F30 and repeats the range F10:F30 till it reaches A100.
However Sometimes I need to start the cyclus from lets say F21 (instead of F10) and then finish the range and repeat from the beginning again until it reaches A10 again.
Dim x, y As Integer
x = 10
Do While x < 100
For y = 10 To 30
Sheets("Sheet1").Cells(x, 1).Value = Sheets("Sheet1").Cells(y, 6).Value
x = x + 1
Next y
Loop
All help is welcome
However Sometimes I need to start the cyclus from lets say F21 (instead of F10) and then finish the range and repeat from the beginning again until it reaches A10 again.
Dim x, y As Integer
x = 10
Do While x < 100
For y = 10 To 30
Sheets("Sheet1").Cells(x, 1).Value = Sheets("Sheet1").Cells(y, 6).Value
x = x + 1
Next y
Loop
All help is welcome