|
代码见后,希望能帮到你。由于Data数据太少,无法验证,自己检查吧。提醒,1月份到2月份之间,均填1月份,后面也这样。
Sub tongji()
Dim ar, br, h As Long, dh As Long, L As Integer, lh As Integer
Application.ScreenUpdating = False
Range("l3:cf" & [b65536].End(3).Row).ClearContents
ar = Range("a1:cf" & [b65536].End(3).Row)
br = Sheet2.Range("a2:j" & Sheet2.[a65536].End(3).Row)
For h = 3 To UBound(ar)
For dh = 2 To UBound(br)
For L = 13 To UBound(ar, 2) Step 6
For lh = 1 To 5
If ar(h, 2) = br(dh, 1) And br(dh, 9) = ar(2, L + lh) And ar(1, L + lh) = br(dh, 10) Then
ar(h, L + lh) = br(dh, 8): ar(h, L) = ar(h, L) + ar(h, L + lh)
ar(h, 12) = ar(h, 12) + ar(h, L + lh)
End If
Next lh
Next L
Next dh
Next h
Range("a1:cf" & [b65536].End(3).Row) = ar
Application.ScreenUpdating = True
End Sub
|
|