|
- Sub Macro1()
- Dim arr, brr, d, d2, i&, j%
- Set d = CreateObject("scripting.dictionary") '数量
- Set d2 = CreateObject("scripting.dictionary") '当日价格
- Sheets("目标表格").Activate
- brr = [a2:af16]
- arr = Sheet1.Range("a2").CurrentRegion
- For i = 3 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- zf = arr(i, 1) & "," & arr(2, j)
- d2(zf) = arr(i, j)
- Next
- Next
- For j = 2 To 4
- arr = Sheets(j).Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- zf = arr(i, 2) & "," & arr(i, 1)
- d(zf) = d(zf) + arr(i, 3)
- Next
- Next
- For i = 2 To UBound(brr)
- For j = 2 To UBound(brr, 2)
- zf = brr(i, 1) & "," & brr(1, j)
- brr(i, j) = d(zf) * d2(zf)
- Next
- Next
- [a2:af16] = brr
- End Sub
复制代码 |
|