|
- Sub 单价()
- Dim arr, brr, crr, d, i&, zf$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("单价表").Range("a1").CurrentRegion
- brr = Range("c3:d" & Range("c65536").End(xlUp).Row)
- ReDim crr(1 To UBound(brr), 1 To 1)
- 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 = 1 To UBound(brr)
- zf = brr(i, 1) & "," & brr(i, 2)
- crr(i, 1) = d(zf)
- Next
- Range("g3").Resize(UBound(crr)) = crr
- End Sub
复制代码- Private Sub Worksheet_Activate()
- Call 单价
- End Sub
复制代码 |
|