|
发表于 2013-8-6 08:07
|
显示全部楼层
本楼为最佳答案
- Sub 今天()
- On Error Resume Next
- Dim arr, sr As String
- arr = Sheets("表一").Range("a2:a" & Sheets("表一").Range("a65535").End(xlUp).Row + 1)
- If UBound(arr) = 0 Then Exit Sub
- 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 arr(j, 1) <> "" And 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
复制代码 |
|