|
For i = 1 To 100 Step 4
Range("B3").Value = Sheets("Sheet1").Range("B" & i)
Range("B1").Value = Sheets("Sheet1").Range("C" & i)
Range("B2").Value = Sheets("Sheet1").Range("D" & i)
Range("I3").Value = Sheets("Sheet1").Range("B" & i+1)
Range("I1").Value = Sheets("Sheet1").Range("C" & i+1)
Range("I2").Value = Sheets("Sheet1").Range("D" & i+1)
Range("B8").Value = Sheets("Sheet1").Range("B" & i+2)
Range("B6").Value = Sheets("Sheet1").Range("C" & i+2)
Range("B7").Value = Sheets("Sheet1").Range("D" & i+2)
:
:
:
Next i
|
|