|
- Sub test() '按条件汇总砼试块强度
- Dim A, B, i, j, Rng
- A = Sheet14.Range("a1").CurrentRegion
- ReDim B(1 To UBound(A) - 2, 1 To 7)
- For i = 3 To UBound(A)
- B(i - 2, 1) = A(i, 6)
- B(i - 2, 2) = A(i, 8)
- B(i - 2, 4) = A(i, 5)
- B(i - 2, 5) = A(i, 7)
- B(i - 2, 6) = A(i, 9)
- B(i - 2, 7) = A(i, 3) & A(i, 4)
- Next i
- Set Rng = Sheet5.Range("a6")
- For i = 1 To UBound(B)
- For j = 1 To UBound(B, 2)
- Rng.Item(1, j) = B(i, j)
- Next j
- Set Rng = Rng.Offset(1, 0)
- If i Mod 16 = 0 Then Set Rng = Rng.Offset(10, 0)
- Next i
- End Sub
复制代码
求助2.rar
(53 KB, 下载次数: 25)
|
|