Formatted Print of Multiple Worksheets

[bigtunelover]

Hi Everyone,

I have been struggling to resolve an issue for some time. I have data from 3 separate worksheets that I need to streamline a printing process for. I would like to be able to print in some simple way, data from all 3 worksheets and have the end result of 1 page of horizontal data and 1 page of vertical data. This printing happens hundreds of times per day and simplifying the process is crucial.

I have an attachment of a mock up of the spreadsheet I am using and can share but it doesn't look like I can post it here. There are 4 worksheets some portions of which I want to include in the print. The last tab (worksheet) is only there to show how I would want the printing formatted, 1 page horizontal of data, and 1 page vertical of additional data.

I have tried using the camera and while this works the printed product does not meet the original standard I need. I assume there is a way to do it from a printing perspective instead but I cant figure it out.

Help please!!

Les

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially the one about cross-posting, and make sure to follow them in future.

Cross-posted at:
https://www.excelforum.com/excel-ge...print-of-multiple-worksheets.html#post5041501
https://www.excelguru.ca/forums/sho...rint-of-Multiple-Worksheets&p=39932#post39932

 

[bigtunelover]

Oops. I didn't know that was a thing. Can I delete this thread? Or can you?

 

[RoryA]

It doesn't need to be deleted; you just need to provide links to the other posts if you do it (It's all in the rules).