|
柔子 发表于 2012-6-6 09:31 ![](static/image/common/back.gif)
不会呀,可以说清楚点吗?谢谢
再来个vba的,请测试!
- Sub test()
- Dim d As Object
- Dim sh As Worksheet
- Dim arr, brr(1 To 10000, 1 To 3)
- Dim i As Long, j As Long, rw As Long
- Dim sr As String
- Set d = CreateObject("scripting.dictionary")
- For Each sh In Worksheets
- If sh.Name Like "表*" Then
- arr = sh.Cells(1, 1).CurrentRegion
- For i = 2 To UBound(arr)
- sr = arr(i, 1) & vbTab & arr(i, 2)
- If d.exists(sr) Then
- rw = d(sr)
- brr(rw, 3) = brr(rw, 3) + arr(i, 3)
- Else
- j = j + 1
- d.Add sr, j
- brr(j, 1) = arr(i, 1)
- brr(j, 2) = arr(i, 2)
- brr(j, 3) = arr(i, 3)
- End If
- Next i
- End If
- Next sh
- With Sheets("汇总")
- .Cells(2, 1).Resize(Rows.Count - 1, 3).ClearContents
- .Cells(2, 1).Resize(j, 3) = brr
- .Cells.EntireColumn.AutoFit
- End With
- Set d = Nothing
- End Sub
复制代码
|
|