|
Sub test()
Dim A, B, i, j, k, s, r
A = Sheets(1).Range("a1").CurrentRegion
B = Sheets(2).Range("a1").CurrentRegion
r = 1
For i = 2 To UBound(A)
For j = i To UBound(A)
s = s + A(j, 2)
If s > 50 Then Exit For
Next j
r = r + 1
For k = i To j - 1
A(k, 3) = B(r, 1)
Next k
s = 0: i = j - 1
Next i
Sheets(1).[a1].Resize(UBound(A), UBound(A, 2)) = A
End Sub
举例2.rar
(11.39 KB, 下载次数: 1)
|
|