|
本帖最后由 sam-wang 于 2022-1-5 16:24 编辑
对,是显示红框的“推荐型号”资料
>>請測試看看,謝謝
Sub test()
Dim Arr, xD, T$, T1$, i&, n%
Set xD = CreateObject("Scripting.Dictionary")
Arr = Sheet1.[a1].CurrentRegion
With Sheet4
T = .[B2] & "|" & .[A2]
For i = 2 To UBound(Arr)
T1 = Arr(i, 1) & "|" & Arr(i, 2)
If T = T1 Then
If InStr(Arr(i, 6), "推") Then
If Not xD.Exists(Arr(i, 4)) Then
n = n + 1: xD(Arr(i, 4)) = n
Arr(n, 1) = Arr(i, 4)
Arr(n, 2) = Arr(i, 5)
End If
End If
End If
Next
If n > 0 Then
.[a4].CurrentRegion.Offset(1) = ""
.[a5].Resize(n, 2) = Arr
End If
End With
End Sub
|
|