Printing Contents Of One Worksheet On The Backside Of Contents Of Another Worksheet

[Ark68]

I'm not sure if I can describe properly what I am trying to do, but here goes.

On worksheet 1, I have a print area of five pages. I'd like to print each page, with contents of worksheet 2 on the reverse. So the print would be something like this

Worksheet 1 Page 1 / Worksheet 2 Page 1
Worksheet 1 Page 2 / Worksheet 2 Page 1
Worksheet 1 Page 3 / Worksheet 2 Page 1
Worksheet 1 Page 4 / Worksheet 2 Page 1
Worksheet 1 Page 5 / Worksheet 2 Page 1

becuase of the interactive nature of the contents of worksheet 1, I'd prefer to avoid putting the contents of Worksheet 2 in line between the pages of Worksheet 1. In fact, I don't think it would work with the different column widths and Row heights between the two worksheets.

 

[John_w]

The macro here should work for you:

VBA to Print Specific Pages From Multiple Sheets to Single PDF with a Specific Name

I have a workbook w 3 tabs that I am looking to write a macro to print in the following manner into a single PDF: Sheet2 = Print pages 1-8 Sheet1 = Print pages 1-4 Sheet3 = Print pages 1-6 Name them with name listed in cell E600 of I am familiar with the below macro, but am admittedly...

www.mrexcel.com

It creates a PDF which can be printed. I think you just need to change the allPages and PDFoutputFile strings.

 

[Ark68]

Hi John, thank you for providing this. And my apologies for taking so long to acknowledge your support. I had to ensure my worksheets were in order before I embarked on this challenge. I have posted a question to the thread provided in post 2.