|
发表于 2022-11-9 15:58
|
显示全部楼层
本楼为最佳答案
Sub test01()
Dim brr() As String
count1 = Sheets("原始数据").[A1].End(xlDown).Row
ReDim Preserve brr(1 To count1, 1 To 7)
k = 1
Sheets("查找").Range("A2:G" & Sheets("查找").[B1].End(xlDown).Row).Clear
arr = Sheets("原始数据").Range("A1:g" & Sheets("原始数据").[A1].End(xlDown).Row)
crr = Sheets("查找").Range("B1:E1")
For i = 1 To UBound(arr)
text1 = ""
For j = 2 To UBound(arr, 2)
text1 = text1 & "|" & arr(i, j)
Next j
For Z = 1 To UBound(crr, 2)
If crr(1, Z) <> "" Then
x = InStr(1, text1, crr(1, Z), vbTextCompare)
If x > 0 Then
For x1 = 1 To 7
brr(k, x1) = arr(i, x1)
Next x1
k = k + 1
Exit For
End If
End If
Next Z
Next i
Sheets("查找").Range("A2").Resize(count1, 7) = brr
Erase arr
Erase brr
Erase crr
End Sub
|
评分
-
查看全部评分
|