|
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("sheet1")
- c = .Cells(2, .Columns.Count).End(xlToLeft).Column
- arr = .Range("aj2").Resize(7, c - 35)
- For j = 1 To UBound(arr, 2)
- xm = arr(1, j) & "+" & arr(3, j)
- d(xm) = arr(7, j)
- Next
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- c = .Cells(30, 1).End(xlToRight).Column
- arr = .Range("a30").Resize(r - 29, c)
- For i = 2 To UBound(arr)
- For j = 4 To UBound(arr, 2)
- xm = arr(i, 2) & "+" & arr(1, j)
- If d.exists(xm) Then
- arr(i, j) = d(xm)
- End If
- Next
- Next
- .Range("a30").Resize(r - 29, c) = arr
- End With
- End Sub
复制代码 |
|