|
- Sub Macro1()
- Dim arr, d, i&, j&, k&, m&, n%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- m = 1
- For i = 1 To UBound(arr)
- If arr(i, 1) Like "数据*" Then
- n = 0
- For j = i + 1 To i + 4
- If Application.CountIf(Columns(1), arr(j, 1)) = 1 Then n = n + 1
- Next
- If n = 4 Then
- Cells(i, 1).Resize(5).Copy Sheet2.Cells(m, 2)
- m = m + 5
- For k = i To i + 4
- arr(k, 1) = ""
- Next
- End If
- End If
- Next
- For i = 1 To UBound(arr)
- If Not arr(i, 1) Like "数据*" Then d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next
- a = d.keys: b = d.items
- For i = 0 To d.Count - 1
- x = s \ 4 + 1
- If b(i) = 1 Then
- s = s + 1
- arr(x + s, 1) = a(i)
- If s Mod 4 = 0 Then arr((s \ 4 - 1) * 5 + 1, 1) = "数据" & s \ 4
- End If
- Next
- Sheet2.Activate
- Range("a1").Resize(x + s) = arr
- End Sub
复制代码 |
|