|
- Private Sub Workbook_Open()
- Call aaa
- End Sub
- Public ar, dd
- Sub aaa()
- Dim i&
- Set dd = CreateObject("scripting.dictionary")
- ar = Sheets("单价").Range("a1").CurrentRegion
- For i = 2 To UBound(ar)
- If ar(i, 2) = "" Then ar(i, 1) = ar(i - 1, 2)
- zf = ar(i, 2) & "," & ar(i, 3)
- dd(zf) = ar(i, 4)
- Next
- End Sub
- Sub Worksheet_Change(ByVal Target As Range)
- If Target.Column = 2 Then
- x = Range([a2], Target).Find("名称:*", SearchDirection:=xlPrevious).Row
- zf = Trim(Mid(Cells(x, 1), 4)) & "," & Target.Value
- Target.Offset(0, 3).Value = dd(zf)
- End If
- End Sub
复制代码 |
|