I'm still not sure what you want for an end result.

Easy enough to add a month's worth of date-named sheets to a new workbook.

Like 01 Jan 2009 through 31 Jan 2009

You can even add sheets just for weekdays...omitting weekends for that month

It is the "double-sided with dates front and back" that confuses me.

Let's say you have a workbook with 31 sheets for January, 2009.

How would you want those 31 sheets printed out?

Would each sheet be one printed page or more?

Which pages would be printed "front and back"?

Would the Date in a header or footer suffice?


Gord

On Sat, 14 Feb 2009 16:04:00 -0800, kayak99
wrote:


Gord, sorry I was tied up on another project and had to stop work with this
one. Yes, 12 workbooks, one for each month would work best. What code would
you use? I'm not very good with macros so please be specific. Thanks




"Gord Dibben" wrote:

Bernie's code to copy Sheet1 and rename to mm dd would give you a workbook
with just one month's sheets.

I think that would be best...........12 workbooks......one for each month,
would be much less unwieldy than 365 sheets in one workbook.

Or you could have 12 sheets, one for each month, in a single workbook.

We could work up code for that if you should choose.

As far as printing on two sides, that would be another set of code to get a
date on each side and would depend upon your printer supporting double-sided
printing.


Gord