|
或者- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- For k = 0 To 1
- xsh = IIf(k = 0, "年度出库", "出库明细")
- arr = Worksheets(xsh).[a1].CurrentRegion
- For i = 3 To UBound(arr)
- xkey = arr(i, 1) & arr(i, 2) '以收货单位和材料编码作为检索条件
- If arr(i, 7) > 0 Then d(xkey) = arr(i, 7)
- Next
- Next
- With Sheet1
- r = .[a65536].End(3).Row
- For i = 4 To r
- xkey = .[h2] & .Cells(i, 1)
- If d.exists(xkey) Then .Cells(i, 6) = d(xkey) Else .Cells(i, 6) = "未找到对应单价"
- Next
- End With
- End Sub
复制代码 |
|