Hello,
I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows.
I have set print titles according to instructions on this page.
https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html
Afterthat I select range F3:AC10 and then print selection (selected area).
The output looks like this
I select by analogy range AD3:AS10 and then print selection...
This output looks like this
Is there any way (for example with help of VBA commandbutton?) how to print both outputs on one page as follows? (I have used graphic editor to join both pictures in one page in order to show how the output should look).
It would be really great if you can help me with this issue.
here is the link for download
https://wetransfer.com/downloads/a15747408a65d80c33db055fd4a2792320191010120340/aded4f
Thank you very much
Miroslav
I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows.
I have set print titles according to instructions on this page.
https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html
Afterthat I select range F3:AC10 and then print selection (selected area).
The output looks like this
I select by analogy range AD3:AS10 and then print selection...
This output looks like this
Is there any way (for example with help of VBA commandbutton?) how to print both outputs on one page as follows? (I have used graphic editor to join both pictures in one page in order to show how the output should look).
It would be really great if you can help me with this issue.
here is the link for download
https://wetransfer.com/downloads/a15747408a65d80c33db055fd4a2792320191010120340/aded4f
Thank you very much
Miroslav
