|
Sub lkyy()
myr = Range("a10000").End(3).Row
ar = Range("a1:L" & myr)
ar2 = Sheet2.Range("a2").CurrentRegion
ar3 = Sheet3.Range("a2").CurrentRegion
Set d2 = CreateObject("Scripting.Dictionary")
Set d3 = CreateObject("Scripting.Dictionary")
For i = 3 To UBound(ar2)
d2(ar2(i, 4)) = ar2(i, 9)
Next
For i = 3 To UBound(ar3)
t = ar3(i, 8) & "|" & ar3(i, 3)
d3(t) = ar3(i, 15)
Next
For i = 3 To UBound(ar)
If d2.exists(ar(i, 2)) Then
Cells(i, "F") = d2(ar(i, 2))
If d2(ar(i, 2)) = "" Then Cells(i, "k") = "主任暂缺"
Else
Cells(i, "k") = "查找不到主任,请检查数据或手工查找"
Cells(i, "L") = "找不到电话号码,请检查数据或手工查找"
End If
t = ar(i, 2) & "|" & Cells(i, "F").Value
If d3.exists(t) Then
Cells(i, "g") = d3(t)
If d3(t) = "" Then Cells(i, "L") = "查找不到电话号码,请检查数据或手工查找"
End If
Next
Set d2 = Nothing
Set d3 = Nothing
End Sub
|
评分
-
2
查看全部评分
-
|