|
ls 发表于 2012-8-19 13:59
可以在一起
只是做模糊查询,把查询到的,复制到最后一表中
- Sub 提取部份02()
- Dim s As String
- Dim k As Byte, j As Long, j1%, i As Long, c As Integer
- Dim a, arr()
- s = Application.InputBox("请输入查找内容", "查找")
- Application.ScreenUpdating = False
- For k = 1 To Sheets.Count - 1
- a = Sheets(k).Range("a5:l" & Sheets(k).UsedRange.Rows.Count)
- For i = 1 To UBound(a)
- If a(i, 3) Like "*" & s & "*" Then
- j = j + 1
- ReDim Preserve arr(1 To 12, 1 To j)
- For c = 1 To 6
- arr(c, j) = a(i, c)
- Next
- End If
- If a(i, 9) Like "*" & s & "*" Then
- j1 = j1 + 1
- ReDim Preserve arr(1 To 12, 1 To j1)
- For c = 7 To 12
- arr(c, j1) = a(i, c)
- Next
- End If
- Next
- Next
- With Sheets(Sheets.Count)
- .Rows("2:10000").ClearContents
- .Range("b:b").NumberFormatLocal = "yyyy-m-d"
- .Range("a2").Resize(j, 12) = Application.Transpose(arr)
- MsgBox "数据已复制!"
- .Select
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码 结果并排放在了同一个表中
|
|