How do I set a manual print order for pages across multiple sheets

**Xori** · 09-14-2012, 02:39 PM

I have a worksheet "Main" that has 5 pages of data. Then, I have worksheets A - E with one page each that correspond to the data on the "Main" worksheet. I would like to set up a print order as follows:
Worksheet Main - Page 1
Worksheet A
Worksheet Main - Page 2
Worksheet B
Worksheet Main - Page 3
etc...

Is there a way to do this?

**Xori** · 09-14-2012, 06:00 PM

To add, it's important to actually set the print order instead of just a macro that sends each page to the printer separately, as I'm trying to create a PDF document where the pages are in the prescribed order.

**Xori** · 09-19-2012, 09:50 PM

I'm kind of new to these forums; is bumping allowed? Haven't seen a response yet...

**Cutter** · 09-20-2012, 09:48 AM

Hello Xori, and welcome to the forum.

Yes, bumping is allowed. The following is from the Forum Rules page:

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.