- Sub 单价()
- Dim arr, brr, d, i&, zf$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("单价表").Range("a1").CurrentRegion
- brr = Range("a1:d" & Range("c65536").End(xlUp).Row)
- For i = 5 To UBound(arr)
- If arr(i, 2) = "" Then arr(i, 2) = arr(i - 1, 2)
- If arr(i, 7) = "" Then arr(i, 7) = arr(i - 1, 7)
- zf = arr(i, 7) & "," & arr(i, 8)
- d(zf) = arr(i, 9)
- zf = arr(i, 2) & "," & arr(i, 3)
- d(zf) = arr(i, 4)
- Next
- For i = 3 To UBound(brr)
- zf = brr(i, 3) & "," & brr(i, 4)
- If d.exists(zf) Then Cells(i, "g") = d(zf)
- Next
- End Sub
复制代码 数组输入改为单元格输入
|