|
本帖最后由 laoau138 于 2017-3-28 21:19 编辑
用VBA汇总结果保存总表 粉红色单元格
- Sub ff()
- Dim d, ar, i&, iget&, t$
- Dim sht As Worksheet
- Dim kr(1 To 65536, 1 To 6)
- Set d = CreateObject("scripting.dictionary")
- For Each sht In Sheets
- If sht.Name <> "總表" Then
- With sht
- ar = .Range("a3", .Cells(Rows.Count, 6).End(3)).Value
- End With
- For i = LBound(ar) To UBound(ar)
- t = ar(i, 1) & ar(i, 2)
- If Len(t) Then
- If Not d.exists(t) Then
- k = k + 1: d(t) = k
- Dim m%, n%
- For m = 1 To 6
- kr(k, m) = ar(i, m)
- Next
- Else
- iget = d(t)
- For n = 3 To 6
- kr(iget, n) = kr(iget, n) + ar(i, n)
- Next
- End If
- End If
- Next
- End If
- Next
- Range("a3", Cells(Rows.Count, 6).End(3)) = ""
- Range("a3:f3").Resize(k) = kr
- Set d = Nothing
- End Sub
复制代码
|
|