|
Sub smhb()
Dim ro As Integer, dic, k As Integer, h As Integer
Dim arr, arrs(1 To 100000, 1 To 2)
Set dic = CreateObject("scripting.dictionary")
arr = Intersect(Sheets("登记表").UsedRange.Offset(1, 0), Sheets("登记表").UsedRange)
For ro = 1 To UBound(arr, 1)
If dic.exists(arr(ro, 1)) Then
h = dic(arr(ro, 1))
arrs(h, 2) = arrs(h, 2) & ";" & arr(ro, 2)
Else
k = k + 1
dic(arr(ro, 1)) = k
arrs(k, 1) = arr(ro, 1)
arrs(k, 2) = arr(ro, 2)
End If
Next
Sheets("汇总表").Cells.Clear
Sheets("登记表").Rows("1:1").Copy Sheets("汇总表").[a1]
Sheets("汇总表").[a2].Resize(k, 2) = arrs
End Sub
|
|