|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub 数据匹配()
Dim d As Object
Set d = CreateObject("scripting.dictionary")
ar = Sheets("记录数据").[a1].CurrentRegion
For i = 2 To UBound(ar)
If Trim(ar(i, 2)) <> "" And Trim(ar(i, 3)) <> "" Then
zf = Trim(ar(i, 2)) & "|" & Trim(ar(i, 3))
d(zf) = i
End If
Next i
With Sheets("汇总表格")
.[a1].CurrentRegion.Offset(1, 1) = Empty
br = .[a1].CurrentRegion
For i = 2 To UBound(br)
If Trim(br(i, 1)) <> "" Then
m = d(Trim(br(i, 1)) & "|切割")
n = d(Trim(br(i, 1)) & "|抛光")
If m <> "" Then
br(i, 2) = ar(m, 4)
End If
If n <> "" Then
br(i, 5) = ar(n, 4)
End If
End If
Next i
.[a1].CurrentRegion = br
End With
MsgBox "ok!"
End Sub
|
|