|
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- arr = Sheets("输入表").[a1].CurrentRegion
- brr = Sheets("查询码表").[a1].CurrentRegion
- ReDim crr(1 To UBound(arr), 1 To 7)
- For i = 2 To UBound(brr)
- d1(brr(i, 1)) = brr(i, 2)
- Next
- For i = 2 To UBound(arr)
- x = arr(i, 2) & arr(i, 3)
- If Len(x) Then
- If Not d.exists(x) Then
- n = n + 1
- d(x) = n
- y = arr(i, 3)
- crr(n, 7) = d1(y) '查询码
- crr(n, 1) = arr(i, 2) '图号
- crr(n, 6) = arr(i, 5) '材料
- yrr = Split(y, " ")
- crr(n, 2) = yrr(0) '名称
- crr(n, 3) = Replace(y, yrr(0), "") '规格型号
- End If
- crr(d(x), 5) = crr(d(x), 5) + arr(i, 4) '数量
- End If
- Next
- With Sheets("输出表")
- .[a2:g10000].ClearContents
- .[a2].Resize(n, 7) = crr
- End With
- End Sub
复制代码 |
|