|
- Sub 按钮1_Click()
- arr = Sheets("表1").UsedRange
- brr = Sheets("表2").UsedRange
- Application.ScreenUpdating = False
- Sheets(3).Select
- ActiveSheet.UsedRange.Offset(1).ClearContents
- For j = 2 To UBound(brr)
- If Len(brr(j, 13)) > 0 Then brr(j, 14) = brr(j, 12) / brr(j, 13)
- Next j
- For j = 2 To UBound(arr)
- m = arr(j, 10)
- For i = 2 To UBound(brr)
- If brr(i, 13) <> 0 Then
- If m <= brr(i, 13) Then
- brr(i, 13) = brr(i, 13) - m
- r = Cells(Rows.Count, 1).End(3).Row + 1
- For x = 1 To UBound(arr, 2) - 2
- Cells(r, x) = arr(j, x)
- Next x
- Cells(r, 10) = m
- Cells(r, 11) = brr(i, 14)
- Exit For
- Else
-
- r = Cells(Rows.Count, 1).End(3).Row + 1
- For x = 1 To UBound(arr, 2) - 2
- Cells(r, x) = arr(j, x)
- Next x
- Cells(r, 10) = brr(i, 13)
- Cells(r, 11) = brr(i, 14)
- m = m - brr(i, 13)
- brr(i, 13) = 0
- End If
- End If
- Next i
- Next j
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|