|
按照你的要求重新修改了,用单元格内的型号来统计,同时修改了一下之前的小差错,贴错了一列。
Sub 合并()
Application.ScreenUpdating = False
Set d = CreateObject("scripting.dictionary")
With Sheets("数据源")
arr = .Range("a2:al" & .Cells(Rows.Count, 3).End(xlUp).Row)
For i = 1 To UBound(arr)
d(CStr(arr(i, 3)) & "-" & arr(i, 8) & "-" & arr(i, 10)) = d(CStr(arr(i, 3)) & "-" & arr(i, 8) & "-" & arr(i, 10)) + arr(i, 5)
Next i
End With
With Sheets("男段")
brr = .Range("a3:e" & .Cells(Rows.Count, 1).End(xlUp).Row)
ReDim crr(1 To UBound(brr), 1 To 20)
For i = 1 To UBound(brr)
For k = 4 To 23
crr(i, k - 3) = d(CStr(brr(i, 3)) & "-" & brr(i, 4) & "-" & brr(i, 5) & "-" & .Cells(2, k + 8).Value)
Next k
Next
.[L3].Resize(UBound(brr), 20) = crr
End With
Application.ScreenUpdating = True
End Sub
|
评分
-
1
查看全部评分
-
|