|
- Sub tt()
- arr = Sheets("产品交接明细").[a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 8)
- crr = Sheets("新产品").[a1].CurrentRegion
-
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- For i = 2 To UBound(crr): d1(crr(i, 1)) = crr(i, 3): Next
- For i = 3 To UBound(arr)
- x = UCase(arr(i, 3) & arr(i, 9)) '型号+客户为key
- If Len(x) > 0 And Not d.exists(x) Then
- n = n + 1: d(x) = n
- brr(n, 1) = arr(i, 3)
- brr(n, 2) = arr(i, 4)
- brr(n, 3) = arr(i, 9)
- brr(n, 8) = d1(arr(i, 3))
- End If
- p = d(x)
- c = IIf(arr(i, 2) = "仓库", 6, 7)
- If arr(i, 6) <> 0 Then brr(p, c) = brr(p, c) + arr(i, 6)
- Next
- If n > 0 Then [a3].Resize(n, 8) = brr
- End Sub
复制代码 |
|