|
- Sub tt()
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- If InStr(arr(i, 4), "婚庆") > 0 Then d(arr(i, 1)) = ""
- Next
- For i = 2 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- n = n + 1
- For j = 1 To UBound(arr, 2): brr(n, j) = arr(i, j): Next
- End If
- Next
- If n > 0 Then
- With Sheet2
- .Cells.ClearContents
- Rows(1).Copy .Rows(1)
- .[a2].Resize(n, UBound(arr, 2)) = brr
- .Activate
- End With
- End If
- End Sub
复制代码 |
|