|
Sub 今天()
On Error Resume Next
Dim arr, sr As String
arr = Sheets("表一").Range("a2:A" & Sheets("表一").Range("a2").End(xlDown).Row)
m = Sheets("表二").Cells.Find("*", , , , , xlPrevious).Row
For i = 1 To m
For n = 1 To Sheets("表二").Rows(i).Find("*", , , , , xlPrevious).Column
q = Sheets("表二").Cells(i, n)
k = 0
For j = 1 To UBound(arr)
If InStr(q, arr(j, 1)) > 0 Then
k = 1
Exit For
End If
Next j
If k = 1 Then
x = Sheets("新建").Cells.Find("*", , , , , xlPrevious).Row
Sheets("表二").Rows(i).Copy Sheets("新建").Range("a" & x + 1)
GoTo 1
End If
Next n
1
Next i
End Sub
|
|