|
- Sub dj_save()
- Dim r, r1, r2 As Long
- r = 3: r2 = 3
- With Sheets("出库打印模板")
- Do While .Cells(r, "B") <> ""
- r = r + 1
- If .Cells(r, "F") <> "" Then r2 = r2 + 1
- If r = 19 Then Exit Do
- Loop
- End With
- ' r = Sheets("出库打印模板").Range("B19").End(xlUp).Row - 3
- ' r2 = Sheets("出库打印模板").Range("F19").End(xlUp).Row - 3
- If r = 3 Or r <> r2 Then
- MsgBox "单据主要区域未填齐!"
- Exit Sub
- End If
- With Sheets("全部出货明细")
- r1 = .Range("b65536").End(xlUp).Row + 1
- .Cells(r1, 2).Resize(r - 3, 1) = Range("B2")
- .Cells(r1, 3).Resize(r - 3, 1) = Range("B4").Resize(r - 3, 1).Value
- .Cells(r1, 4).Resize(r - 3, 1) = Range("C4").Resize(r - 3, 1).Value '表中的的第5列取单据表中的B4中的值,下同
- .Cells(r1, 5).Resize(r - 3, 1) = Range("D4").Resize(r - 3, 1).Value
- .Cells(r1, 6).Resize(r - 3, 1) = Range("E4").Resize(r - 3, 1).Value
- .Cells(r1, 7).Resize(r - 3, 1) = Range("F4").Resize(r - 3, 1).Value
- .Cells(r1, 8).Resize(r - 3, 1) = Range("G4").Resize(r - 3, 1).Value
- .Cells(r1, 9).Resize(r - 3, 1) = Range("E2")
- MsgBox "单据保存成功!"
- End With
- Cells(4, "B").Resize(16, 1).ClearContents
- Cells(4, "E").Resize(16, 2).ClearContents
- End Sub
复制代码 |
|