multiple sheet custom printing

[Diesel13]

Hi, Me again, last year I made a spreadsheet for my pool league.

I would like to automate something but don't know where to begin this (for most of you) simple task.

I included my work, and the password to unlock the sheets in Moose .

What I would like to do is print the first 25 sheets on one side and sheet 26 (Player DATA) in the rear of those 25 sheets and then print sheet 27 (Marie-Ève) by itself.

There must be a way to do this using a macro or something that when I press print (or a custom button) the paper will magically appear on my printer ?

I'm not really good at excel but I learn quite fast.

And also, the first 25 sheets, are printed normally but on the reverse where Player DATA is printed, it has to be printed in draft mode (light printing).

I already have all the printing settings saved in my pc as I manually print them every weeks, I print the first 25, then re insert them then print player data and I then print Marie-Ève.

I use an Epson Artisan 800 with the auto duplexer attachment, Windows 7 64bits ultimate and office 2007.

Please help me, I'm lost on this one . . .

[Diesel13]

Bump !

Wow, somebody must know how to do this ?

Should actually be easy for most people here, I just don't have a clu as to how to do it . . .

[royUK]

See Andy Pope's answer in this earlier post

[Diesel13]

see, that's the thing, I know how to duplex print, that's not the problem, the problem is I cannot figure out how to print all the first 25 (each different) sheets of the workbook and print sheet 26 (Player DATA) on the reverse of those 25 sheets, so I need 25 different sheets all with the same sheet printed in the back, and I'd like to print sheet 27 as well with nothing on the reverse, and to do it all in one shot, click print once and the whole thing gets done automatically.

That's where I'm stuck.

Sorry if I seem like I'm loosing my patience, it's because I am, I'm getting frustrated because I cannot find a solution and God knows I have searched . . .

So, any help would be greatly appreciated.

[Diesel13]

Bump . . .

Please people, there should be a way to write a macro that would allow this quite simple task ?

Does anyone know how to do this ?

You guys (and gals) helped me do some pretty amazing things in my project, this should be a walk in the park . . .

Thanks in advance

Mike.