|
之前dsmch老师写过一个,没太看懂代码的意思,现在数据源改了,烦劳哪位大师帮忙改一下代码,万分感谢!
- Sub Macro1()
- On Error Resume Next
- Sheets("配料").Activate
- With Sheet2
- For i = 2 To Range("a65536").End(xlUp).Row
- jm = Cells(i, 1): sl = Cells(i, 4): p = ""
- For j = 2 To .Range("a65536").End(xlUp).Row
- If .Cells(j, 4) = jm And .Cells(j, "m") > 0 Then
- p = p & .Cells(j, 3) & "," & .Cells(j, "k")
- If sl >= .Cells(j, "m") Then
- p = p & "," & .Cells(j, "m") & Chr(10)
- sl = sl - .Cells(j, "m")
- .Cells(j, "m") = 0
- Else
- p = p & "," & sl & Chr(10)
- .Cells(j, "m") = .Cells(j, "m") - sl
- Exit For
- End If
- End If
- Next
- Cells(i, 6) = p
- Next
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|