日月和 发表于 2016-7-8 15:22
筛选是用“包含”条件
附件
把所有要命名后的名称种类写在A列就行
Sub xx()
For i = 2 To Range("B65536").End(xlUp).Row
Cells(i, "C") = ""
For j = 2 To Range("A65536").End(xlUp).Row
If InStr(1, Cells(i, "B"), Cells(j, "A")) > 0 Then
Cells(i, "C") = Cells(j, "A")
Exit For
End If
Next
Next
End Sub