- Sub test()
- Dim arr, ar, brr(100, 1 To 6), i%, j%, k%, n%
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- For j = 1 To arr(i, 5)
- n = n + 1
- For k = 1 To 6
- If k <> 5 Then
-
- brr(n, k) = arr(i, k)
- End If
-
- Next
- brr(n, 5) = 1
- Next
- Next
- ar = Array("ID", "码号", "产品", "名称", "数量", "地点")
- For i = 1 To 6
- brr(0, i) = ar(i - 1)
- Next
- [a10].Resize(n, 6) = brr
- End Sub
复制代码
11.rar
(12.77 KB, 下载次数: 1)
|