Sub keyWordFilter()
Dim sht1 As Worksheet, sht2 As Worksheet, sht3 As Worksheet, maxRow1 As Integer, maxRow2 As Integer, maxRow3 As Integer, userName As String, i As Integer, j As Integer, keyWord As String, k As Integer
Set sht1 = ThisWorkbook.Sheets("Sheet1")
Set sht2 = ThisWorkbook.Sheets("Sheet2")
Set sht3 = ThisWorkbook.Sheets("Sheet3")
'基础信息表 行数
maxRow1 = sht1.Cells(Rows.Count, 1).End(xlUp).Row
'关键字表 行数
maxRow2 = sht2.Cells(Rows.Count, 1).End(xlUp).Row
'结果表 行数
maxRow3 = sht3.Cells(Rows.Count, 1).End(xlUp).Row
sht3.Rows("2:" & maxRow3).ClearContents '清空【结果表】上次留存结果，保留抬头行
k = 2
For i = 2 To maxRow1
userName = sht1.Cells(i, 2).Value
For j = 2 To maxRow2
keyWord = sht2.Cells(j, 1).Value
If userName Like "*" & keyWord & "*" Then '判断某个基础信息是否包含某个关键字
sht3.Cells(k, 1).Value = sht1.Cells(i, 1).Value
sht3.Cells(k, 2).Value = sht1.Cells(i, 2).Value
sht3.Cells(k, 3).Value = sht1.Cells(i, 3).Value
k = k + 1
Exit For
End If
Next
Next
End Sub
标签：sht1,sht3,End,Cells,Value,关键字,Integer,excle,文本 From： https://www.cnblogs.com/suheng01/p/17527680.html