本帖最后由 我行我速2008 于 2022-8-23 11:41 编辑
Sub tt()
Dim ar, br(), r%, k%
Sheet2.[a1].CurrentRegion.Clear
ar = Sheet1.[a1].CurrentRegion
ReDim br(1 To UBound(ar), 1 To 2)
For r = 1 To UBound(ar)
br(r, 1) = ar(r, 3): br(r, 2) = ar(r, 5)
Next r
For k = 1 To Sheet1.Cells(3, 9)
Sheet2.Cells(1 + UBound(ar) * (k - 1), 1).Resize(UBound(ar), 2) = br
Next k
End Sub