Excel VBA如何实现自动生成出入库凭证

试试以下代码

Sub Worksheet_Change(ByVal Target As Range)If Target.Row > 1 And Target.Column > 4 And Target.Column < 7 Theni = Target.RowCells(i, 7) = Cells(i - 1, 7) + Cells(i, 5) - Cells(i, 6)End IfEnd Sub

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/vx77yyejrr23rvv2y27.html