楼主Dim arr, arrQ, C, arrT(1 To 24, 1 To 10)
C = 42
arr = Range("d5").Resize(200, 33): arrQ = Range("b5").Resize(200, 1)
For u = 1 To 200
For i = 1 To 24
For k = 1 To 10
m = m + 1
arrT(i, k) = arr(u, m)
Next
m = m - 9
Next
m = 0
C = IIf(u = 1, C, C + 11)
Cells(3, C) = arrQ(u, 1)
Cells(5, C).Resize(24, 10) = arrT
Next
MsgBox "完成", 64, "提示:"
End Sub