|
发表于 2012-10-9 14:22
|
显示全部楼层
本楼为最佳答案
本帖最后由 suye1010 于 2012-10-9 14:28 编辑
- Option Explicit
- Sub Sta()
- Dim i%, j%, k%, arr0, arr, d, TempArr
- arr0 = Workbooks("统计.xlsx").Sheets(1).UsedRange
- arr = Sheets(1).Range("A1").CurrentRegion
- Set d = CreateObject("Scripting.Dictionary")
- For i = 1 To UBound(arr0)
- d.Add arr0(i, 3) & arr0(i, 1), Split(arr0(i, 4), ",")
- Next i
- For j = 1 To UBound(arr)
- If d.exists(arr(j, 1) & arr(j, 3)) Then
- TempArr = d(arr(j, 1) & arr(j, 3))
- For k = 0 To UBound(TempArr)
- arr(j, 10 + k * 2) = TempArr(k)
- Next k
- End If
- Next j
- Sheets(1).Cells(1, 1).Resize(UBound(arr, 1), UBound(arr, 2)) = arr
- End Sub
复制代码 |
|