|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 匹配()
- Dim arr, brr, i, j, r, d, d1
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- With Sheet1
- r = .Cells(Rows.Count, 1).End(xlUp).Row
- arr = .Range("a1:h" & r)
- End With
- brr = Sheet2.Range("a1").CurrentRegion
- For j = 2 To UBound(brr)
- d1(brr(j, 1)) = j
- Next
- For i = 3 To UBound(arr)
- rq = CDate(Split(arr(i, 1), " ")(0))
- If Not d.exists(rq) Then
- d(rq) = i
- End If
- Next
- With Sheet1
- For Each k In d.keys
- .Cells(d(k), "f") = brr(d1(k), 5)
- .Cells(d(k), "g") = brr(d1(k), 6)
- .Cells(d(k), "h") = brr(d1(k), 7)
- Next
- End With
- End Sub
复制代码 |
|