Print two copies of the selected area one below another

[ppgab]

Hello, I have this simple invoice/inventory excel that with a simple print ("imprimir") button on it :

Please Login or Register  to view this content.

The invoice fits exactly on the middle of the paper, so at the moment I'm printing, flipping the paper and printing it again on the other side, I need a way to just print two copies of it one below another in the same paper since in big amounts it is becoming too much time wasted

Bonus points if it doesn't mess with how the worksheet looks

Thanks for the attention!

Here's how it looks :
IaBtSY6.png

[mongoose36]

A sample workbook would be helpful. Also it seems like the invoice takes up a whole 8.5" x 11" sheet of paper...how are you thinking another invoice can fit below it on the same sheet? Please explain.

[ppgab]

A sample workbook would be helpful. Also it seems like the invoice takes up a whole 8.5" x 11" sheet of paper...how are you thinking another invoice can fit below it on the same sheet? Please explain.

A1:F28 does fit twice in the paper, as I said I'm printing two times by flipping the paper.

If a sample is really needed I could try, but its really just that print function I need to fiddle with

[mongoose36]

If it does fit on one sheet why not copy range "A1:F28" and paste it to "A29" then execute your printout command and delete the copied rows when you are done. Something like...

Please Login or Register  to view this content.

[ppgab]

If it does fit on one sheet why not copy range "A1:F28" and paste it to "A29" then execute your printout command and delete the copied rows when you are done. Something like...

Please Login or Register  to view this content.

Thanks, I just didn't know the methods to use