|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
模块中输入以下代码
- Sub 复制()
- With Worksheets("开票")
- rrow = .Range("c5").End(xlDown).Row
- rrow1 = Worksheets("流水").Range("a65536").End(xlUp).Row + 1
- If rrow > 5 Then
- ar = .Range("b6:b" & rrow)
- Worksheets("流水").Range("a" & rrow1).Resize(UBound(ar), 1) = ar
- br = .Range("c6:i" & rrow)
- Worksheets("流水").Range("e" & rrow1).Resize(UBound(br, 1), UBound(br, 2)) = br
- Else
- End If
- For i = 1 To UBound(ar)
- Worksheets("流水").Cells(i + rrow1 - 1, "b") = .Range("i3").Value
- Worksheets("流水").Cells(i + rrow1 - 1, "c") = .Range("d3")
- Next
- End With
- End Sub
复制代码
开票表格中输入以下代码
- Private Sub CommandButton1_Click()
- 复制
- End Sub
复制代码 |
|