|
- Sub Macro1()
- On Error Resume Next
- Dim arr, brr, d, i%, j&, k%
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To 7
- arr = Sheets(i).Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2) - 3)
- s = 0
- Sheets(i).[e1:m1].Copy Sheets(i + 6).[b2]
- For j = 2 To UBound(arr)
- If arr(j, 2) = "学校" Then GoTo 100
- If Not d.exists(arr(j, 2)) Then
- s = s + 1
- d(arr(j, 2)) = s
- For k = 5 To UBound(arr, 2)
- brr(s, 1) = arr(j, 2)
- brr(s, k - 3) = arr(j, k)
- Next
- Else
- n = d(arr(j, 2))
- For k = 5 To UBound(arr, 2)
- brr(n, k - 3) = brr(n, k - 3) + arr(j, k)
- Next
- End If
- 100:
- Next
- Sheets(i + 6).Range("a3").Resize(s, UBound(brr, 2)) = brr
- d.RemoveAll
- Next
- End Sub
复制代码 |
|