|
- Sub Macro1()
- Dim arr, brr, crr, d, i&, cpm$, js&
- Set d = CreateObject("scripting.dictionary")
- cpm = [b2].Value: js = [b9] '产品名、计数
- arr = Range("a11").Resize(js, 2)
- ReDim crr(1 To UBound(arr), 1 To 1)
- brr = Sheet2.[b2:f6]
- For i = 1 To UBound(brr)
- d(brr(i, 1)) = brr(i, 5)
- Next
- x = d(cpm)
- For i = 1 To UBound(arr)
- crr(i, 1) = arr(i, 2) - x
- Next
- Range("c11").Resize(UBound(crr)) = crr
- End Sub
复制代码 |
|