|
- Sub 分类()
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets(1).[a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 2 To 8)
- For i = 2 To UBound(arr)
- x = arr(i, 2) & arr(i, 3) & arr(i, 4)
- If Not d.exists(x) Then
- n = n + 1
- d(x) = n
- For j = 2 To 5
- brr(n, j) = arr(i, j)
- Next
- End If
- p = d(x)
- For j = 6 To 8
- brr(p, j) = brr(p, j) + Val(arr(i, j))
- Next
- Next
- If n > 0 Then
- With Sheets("汇总求和")
- .Rows("2:65536").ClearContents
- .[a2].Resize(n, 7) = brr
- .Select
- End With
- End If
-
- End Sub
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|