楼主附件中似乎漏掉2元这一档
从通用角度考虑,应算到"角"(有角无角均适用/分位就不必要了)
最后宜加个合计
参考附件(在一楼程式基础上更改)
Sub bzs()
Application.ScreenUpdating = False
Dim x#, y#, r&, i&, j&
r = [B1].End(4).Row
For i = 2 To r
x = Cells(i, 2).Value
For j = 3 To 12
If j < 10 Then y = Int(x) Else y = Application.Round(x - Int(x), 1)
Cells(i, j).Value = Int(y / (Cells(1, j)))
x = x - Cells(i, j) * Cells(1, j)
Cells(r + 2, j) = Application.Sum(Range(Cells(2, j), Cells(r, j)))
Next
Next
Cells(r + 2, 1) = "合计(张)": Cells(r + 2, 2) = Application.Sum(Range(Cells(2, 2), Cells(r, 2)))
Application.ScreenUpdating = True
End Sub
|