I want to have the following VBA macro:
- A certain range of sheet X is copied into another worksheet
- At the end of the copied range, there are two free lines
- Below these two free lines, a certain range of sheet X+1 is copied into the worksheet
- etc etc
- In case the copied part can not completely paste on the page of the excel sheet (=> important for printing), the entire copied range shall be placed on the next printed page.
Hello, I can do this for you now if you'd like. If you have an example workbook that you are working from I can take a look. I look forward to helping out.