|
本帖最后由 ppp710715 于 2014-5-21 09:11 编辑
- Sub test111()
- Dim arr, brr, crr, i, j, m, k, drr
- Dim sh As Worksheet
- On Error Resume Next
- Application.DisplayAlerts = False
- Set d = CreateObject("scripting.dictionary")
- For Each sh In Sheets
- If sh.Name = "汇总" Then
- sh.Delete
- End If
- Next
- arr = Sheet1.Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- d.Add arr(i, 3) & arr(i, 4) & arr(i, 5) & arr(i, 6), i
- Next
- brr = d.Keys
- ReDim crr(1 To d.Count, 1 To 21)
- For j = 0 To UBound(brr)
- m = d(brr(j))
- For k = 1 To 21
- crr(j + 1, k) = arr(m, k)
- Next k
- Next j
- drr = Sheets("原始表").[a1:u1]
- Worksheets.Add after:=Sheets(Worksheets.Count)
- ActiveSheet.Name = "汇总"
- With Sheets("汇总")
- .[a1].Resize(1, 21) = drr
- .Range("a2").Resize(j, 21) = crr
- End With
- Application.DisplayAlerts = true
- End Sub
复制代码 |
评分
-
查看全部评分
|