|
本帖最后由 335081548 于 2012-1-4 00:27 编辑
其他还没做出来
- Sub 必做二_5201314()
- '学号A018 论坛ID:5201314
- Dim dic As New Dictionary
- Dim dic1 As New Dictionary
- Dim dic2 As New Dictionary
- Dim arr, sht As Worksheet
- Dim DicKeys, k As Integer
- Dim i As Integer
- Dim LastRow As Integer
- Dim brr(1 To 12, 1 To 5)
- For Each sht In Sheets
- If sht.Name = "必二1" Or sht.Name = "必二2" Then
- LastRow = sht.Range("A65536").End(xlUp).Row
- arr = sht.Range("A1:E" & LastRow).Value
- For i = 2 To LastRow
- If Not dic.Exists(arr(i, 5)) Then k = k + 1: dic(arr(i, 5)) = k
- If Not dic1.Exists(arr(i, 2)) Then dic1(arr(i, 2)) = arr(i, 2)
- brr(dic1(arr(i, 2)), dic(arr(i, 5))) = dic2(dic1(arr(i, 2)) & dic(arr(i, 5))) + arr(i, 4)
- Next
- End If
- Next
- DicKeys = dic.Keys
- With Sheets("必做二")
- .Range("C:G").ClearContents
- .Range("C1").Resize(1, dic.Count) = Application.Transpose(Application.Transpose(DicKeys))
- .Range("C2").Resize(12, dic.Count) = brr
- End With
- End Sub
复制代码
|
评分
-
查看全部评分
|