|
- Sub gg()
- Dim qp(1 To 10000, 1 To 3)
- Dim hs
- Dim arr, x As Integer, sr As String, k As Integer
- Dim dd As New Dictionary
- Set dd = CreateObject("scripting.dictionary")
- arr = Sheets2.Range("b3:d" & Range("d65536").End(xlUp).Row)
- For x = 1 To UBound(arr)
- sr = arr(x, 1) & "-" & arr(x, 2)
- If dd.Exists(sr) Then
- hs = dd(sr)
- qp(hs, 3) = qp(hs, 3) ' + arr(x, 3)
- Else
- k = k + 1
- dd(sr) = k
- qp(k, 1) = arr(x, 1)
- qp(k, 2) = arr(x, 2)
- qp(k, 3) = arr(x, 3)
- End If
- Next x
- Sheet4.Range("b6:d" & sheets(4).cells(rows.count,2).end(3).row+1).clearcontents
- Sheet4.Range("b6").Resize(k, 3) = qp
- End Sub
复制代码 |
|