|
参与一下。。。
- Sub ykcbf() '//2024.5.7
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("查找")
- r = .Cells(Rows.Count, "t").End(3).Row
- arr = .[t1].Resize(r, 3)
- For i = 3 To UBound(arr)
- s = CStr(arr(i, 1)) & "|" & CStr(arr(i, 2))
- d(s) = arr(i, 3)
- Next
- r = .Cells(Rows.Count, "n").End(3).Row
- arr = .[n1].Resize(r, 4)
- For i = 3 To UBound(arr)
- s = CStr(arr(i, 2)) & "|" & CStr(arr(i, 3))
- If d.exists(s) Then
- arr(i, 4) = d(s)
- End If
- Next
- .Columns("n:p").NumberFormatLocal = "@"
- .[n1].Resize(r, 4) = arr
- d.RemoveAll
- arr = .[n1].Resize(r, 4)
- For i = 3 To UBound(arr)
- s = CStr(arr(i, 1))
- d(s) = i
- Next
- r = .Cells(Rows.Count, "a").End(3).Row
- brr = .[a1].Resize(r, 11)
- ReDim crr(1 To r, 1 To 3)
- For i = 3 To UBound(brr)
- s = CStr(brr(i, 3))
- m = m + 1
- If d.exists(s) Then
- crr(m, 1) = arr(d(s), 2)
- crr(m, 2) = arr(d(s), 3)
- crr(m, 3) = arr(d(s), 4)
- End If
- Next
- .Columns("i:k").NumberFormatLocal = "@"
- .[i3].Resize(m, 3) = crr
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|