|
Sub tj()
Dim d As Object
Set d = CreateObject("scripting.dictionary")
Dim ar As Variant, br As Variant
Dim i As Integer
With Sheets("正课")
r = .Cells(Rows.Count, 16).End(xlUp).Row
.Range("q3:s" & r) = Empty
ar = .Range("p1:s" & r)
rs = .Cells(Rows.Count, 1).End(xlUp).Row
br = .Range("a1:n" & rs)
For i = 3 To UBound(ar)
If Trim(ar(i, 1)) <> "" Then
d(Trim(ar(i, 1))) = i
End If
Next i
For j = 1 To UBound(br, 2) Step 2
For i = 1 To UBound(br)
If Trim(br(i, j)) <> "" Then
n = d(Trim(br(i, j)))
If n <> "" Then
If Trim(br(1, j)) = "语文" Or Trim(br(1, j)) = "数学" Or Trim(br(1, j)) = "英语" Then
m = 2
ElseIf Trim(br(1, j)) = "政治" Or Trim(br(1, j)) = "政治" Then
m = 3
ElseIf Trim(br(1, j)) <> "语文" And Trim(br(1, j)) <> "数学" And Trim(br(1, j)) <> "英语" And Trim(br(1, j)) <> "政治" And Trim(br(1, j)) <> "政治" Then
m = 4
End If
ar(n, m) = ar(n, m) + br(i, j + 1)
End If
End If
Next i
Next j
.Range("p1:s" & r) = ar
End With
MsgBox "ok!"
End Sub
|
|