tommyleinen
Board Regular
- Joined
- Aug 22, 2009
- Messages
- 74
I have 3 sheets as part of a much larger workbook. I started with all the info on one sheet but due to problems with the widths being different I have split the information over 3 sheets as there are 3 different widths (the widest makes the slimmest appear tiny when I print all off the same sheet, so I would like to maximise each page).
So my work around is for a macro to print the information in the order I require. i.e:
sheet1 page 1 and 2 (finished that sheet), sheet2 pages 1,2,3, sheet3 page 1, sheet2 pages 4,5,6, sheet3 page 2, sheet2 pages 7,8,9, sheet3 page3, sheet2 pages 10,11,12, sheet3 page 4, and so on in the same pattern until sheet3 page6 is done.
Can this be done easily with a macro?
If so can anybody help? Thanks in advance.
So my work around is for a macro to print the information in the order I require. i.e:
sheet1 page 1 and 2 (finished that sheet), sheet2 pages 1,2,3, sheet3 page 1, sheet2 pages 4,5,6, sheet3 page 2, sheet2 pages 7,8,9, sheet3 page3, sheet2 pages 10,11,12, sheet3 page 4, and so on in the same pattern until sheet3 page6 is done.
Can this be done easily with a macro?
If so can anybody help? Thanks in advance.
