|
发表于 2014-12-24 21:28
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim A, B, i, j, k, s, n
A = Sheets(2).[A1:AF35]
ReDim B(1 To UBound(A), 1 To UBound(A, 2))
n = 7
For k = 1 To n
For i = k To UBound(A) Step n
s = s + 1
For j = 1 To UBound(A, 2)
B(s, j) = A(i, j)
Next j
Next i
Next k
Sheets(3).UsedRange = ""
Sheets(3).[a1].Resize(UBound(B), UBound(B, 2)) = B
End Sub
把工作表2各表中数据复制到工作表3各对应表中.rar
(26.65 KB, 下载次数: 10)
|
|