|
发表于 2016-2-20 16:35
|
显示全部楼层
本楼为最佳答案
全部汇总到总表里了,
测试一下结果。- Sub test()
- Dim sh, arr, ar, brr(10000, 6), i&, j&, n&
- ar = Array("产品型号", "图号", "零件名称", "工序", "单价元", "合计元", "单位")
- For i = 0 To UBound(ar)
- brr(0, i) = ar(i)
- Next
- ar = Array(2, 3, 4, 6, 11, 12)
- For Each sh In Sheets
- If sh.Name <> "总表" Then
- With sh
- arr = .Range("a1:l" & .[f65536].End(3).Row)
- End With
- For i = 1 To UBound(arr)
- If Len(arr(i, 6)) And Trim(arr(i, 6)) <> "工序" Then
- n = n + 1
- For j = 0 To UBound(ar)
- brr(n, j) = arr(i, ar(j))
- Next
- brr(n, 6) = sh.Name
- End If
- Next
- End If
- Next
- With Sheets("总表")
- .Cells.ClearContents
- .[a1].Resize(n, 7) = brr
- End With
- MsgBox "汇总结束!"
- End Sub
复制代码
数据源.rar
(104.3 KB, 下载次数: 6)
|
|