本帖最后由 dehaijun2 于 2016-8-19 23:49 编辑
横列转成竖列数据格式,麻烦高手帮助改下附件的代码..
附件在2楼
- Sub test()
- Dim arr, brr(1 To 10000, 1 To 6), i&, j%, k%, n&, m#
- arr = Range("a4").CurrentRegion
- For i = 4 To UBound(arr)
- If arr(i, UBound(arr, 2)) = "OK" Then
- For j = 8 To UBound(arr, 2) - 1 Step 2
- If arr(i, j + 1) > 0 Then
- n = n + 1
- For k = 1 To 3
- brr(n, k) = arr(i, k)
- Next
- brr(n, 4) = arr(i, j)
- brr(n, 5) = arr(i, 5)
- brr(n, 6) = arr(i, j + 1)
- m = m + arr(i, j + 1)
- End If
- Next
- End If
- Next
- n = n + 2
- brr(n, 1) = "合计:": brr(n, 6) = m
- [a4003:f65536] = ""
- [a4003].Resize(n, 6) = brr
- End Sub
复制代码
11.rar
(35.79 KB, 下载次数: 5)
|