VBA自动保存效果:保存到《现金日记账》的E列最后一个空单元所在行,G2存到《现金日记账》的A列,H2存到《现金日记账》的B列,D2存到《现金日记账》的C列,B6:B的物品名称合并存到《现金日记账》的E列,F5存到《现金日记账》的I列。效果图在附件。
加了一句
Sub x()
Dim k, x
With Sheets("现金日记账")
If Application.CountIf(.[c:c], Range("d2")) > 0 Then Exit Sub
x = .Cells(Rows.Count, 1).End(3).Row + 1
.Cells(x, 1) = Range("g2"): .Cells(x, 2) = Range("h2")
For k = 6 To Range("b45000").End(3).Row
st = st & "、" & Cells(k, 2)
Next
.Cells(x, 5) = Mid(st, 2): .Cells(x, 5).Font.Size = 8
.Cells(x, 3) = Range("d2"): .Cells(x, "i") = Range("f5")
End With
MsgBox "保存成功"
End Sub
|