Automatically adding a blank page at the end of sheets with page count odd

[NewDawn999]

Hello! many times i need to print excel files containing (lets say) 40 different sheets and have to print them double sided. i can print multiple sheets at once by shift selecting them from the bottom tabs and then hitting ctr+p and selecting active sheets, but if one or more of these sheets have odd page counts then im screwed. so i need something that automatically adds a blank page that will print at the end of odd page count sheets. is this possible? it must do it all at once for all the sheets that i select. im hoping there is a solution, cos i know i had the same problem with pdfs and i eventually found an action that does the trick.

thanks in advance, cheers!

[Leith Ross]

Hello NewDawn999,

I find it odd, no pun intended, your printer does not balance the page output for you automatically when doing double sided printing. Have you checked your printer setup to see if it automatically add the blank page for you?

[NewDawn999]

thats the thing, if i select 3 sheets each with odd page count, page 1 from the second sheet will be printed on the back of the last page of the first sheet and thats what i need to avoid.

[Leith Ross]

Hello NewDawn999,

Okay, I think I get what you mean. Each sheet that is printed must have an even number of pages on each sheet. You aren't referring to physical sheet count, "Sheet1", "Sheet2", and "Sheet3" which would be 3 pages, correct?

[NewDawn999]

no, what i mean by page count is the number of pages of each single sheet. for example 1 sheet has a table that extends through 3 a4 pages. "3" is the page count in this case. but when i print it i need a fourth blank page(again for this case) to be added. and this done automatically for all the active sheets or the sheets that i select. so if the page count is even, nothing happens, if its odd, 1 blank page added. do this test, apply changes if its the case then go to the next sheet and repeat, thats how i imagine the programming logic for this, i dont have the knowledge to do it myself tho. hope i have been clear.

[NewDawn999]

a little bump.

[NewDawn999]

really no ideeas?

[NewDawn999]

trying to bump again...

[NewDawn999]

bump plssssssssssss