|
- Sub tt()
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 4)
- 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 4: brr(n, j) = arr(i, j): Next
- End If
- Next
- If n > 0 Then
- [h:k].ClearContents
- [h1].Resize(1, 4) = Array("小票编号", "销售数量", "销", "商品类别")
- [h2].Resize(n, 4) = brr
- End If
- End Sub
复制代码 |
|