Hi everyone, I am using Excell 2003 and I need some help figuring out how to print worksheets in a workbook in a different order than they are displayed in the workbook.
For example, the workbook has the following worksheets:
1,2,3,4,A,B,C,D
I need them in this order because I subtotal 1,2,3,4 and A,B,C,D separately.
But, I need to print them as follows:
1,A,2,B,3,C,4,D
Becasue 1 is paired with A; 2 with B; and so on.
I found this macro that allows me to (1) see all the sheets in the workbook, (2) select only the sheets I want to print and, (3) print all the sheets together to maintain the numbering sequence.
http://spreadsheetpage.com/index.php/tip/displaying_a_menu_of_worksheets_to_print/
This macro does not allow me to rearrange the worksheets how I need them to be.
My current solution involves removing the Excel page number footers, creating a PDF, rearranging, numbering and printing from Adobe.
Does anyone know of a way I can modify the above code to rearrange the sheets in the workbook for printing?
Any help will be greaty appreciated.
Cheers,
N
For example, the workbook has the following worksheets:
1,2,3,4,A,B,C,D
I need them in this order because I subtotal 1,2,3,4 and A,B,C,D separately.
But, I need to print them as follows:
1,A,2,B,3,C,4,D
Becasue 1 is paired with A; 2 with B; and so on.
I found this macro that allows me to (1) see all the sheets in the workbook, (2) select only the sheets I want to print and, (3) print all the sheets together to maintain the numbering sequence.
http://spreadsheetpage.com/index.php/tip/displaying_a_menu_of_worksheets_to_print/
This macro does not allow me to rearrange the worksheets how I need them to be.
My current solution involves removing the Excel page number footers, creating a PDF, rearranging, numbering and printing from Adobe.
Does anyone know of a way I can modify the above code to rearrange the sheets in the workbook for printing?
Any help will be greaty appreciated.
Cheers,
N
Last edited:
