|
Sub 按钮1_Click()
Dim A, B, je, sl, n, i
Sheets(1).Select
A = Range("a1").CurrentRegion
Set je = CreateObject("scripting.dictionary")
Set sl = CreateObject("scripting.dictionary")
For n = 2 To Sheets.Count
If Sheets(n).Range("a1").CurrentRegion.Rows.Count > 3 Then
B = Sheets(n).Range("a1").CurrentRegion
For i = 3 To UBound(B)
je(B(i, 1)) = je(B(i, 1)) + B(i, 2)
sl(B(i, 1)) = sl(B(i, 1)) + B(i, 4)
Next i
End If
Next n
Range("a3").Resize(je.Count) = Application.Transpose(je.keys)
Range("b3").Resize(je.Count) = Application.Transpose(je.items)
Range("c3").Resize(je.Count) = Application.Transpose(sl.items)
End Sub
只汇总数量与金额不要单价2.rar
(26.71 KB, 下载次数: 11)
|
评分
-
查看全部评分
|