Sub 提取()
Dim m
Sheets("结果").Range("A3:F65500").Clear
For I = 1 To Range("B65536").End(3).Row
m = Application.InputBox("请输入查找内容", "查找")
If Range("C" & I) Like "*" & m & "*" Then Range("A" & I & ":F" & I).Copy Sheets("结果").Range("B65536").End(3).Offset(1, -1)
If Range("i" & I) Like "*" & m & "*" Then Range("g" & I & ":l" & I).Copy Sheets("结果").Range("B65536").End(3).Offset(1, -1)
If Range("o" & I) Like "*" & m & "*" Then Range("m" & I & ":r" & I).Copy Sheets("结果").Range("B65536").End(3).Offset(1, -1)