A very simple macro can create a new workbook with 52 sheets and add dates
into to each sheet automatically. I need to know how your work weeks are set
up and what you want on each sheet. There are lots of variations in work
weeks. Start Saturday, Start Sunday, Start Monday? Does you year Start on
the 1st of January, or the first monday of the year. Are days from previous
year shown? wehat do you want the tabs to show on each sheet? Do you want
header rows on each sheet and what do they contain. Dou you want any headers
and footers put on each sheet? What do you want the new work book called.

This is all really very simple, but there are millions of solutions. the
macro will run in about 10 seconds and take about 10 minutes to write. It
will save your hours of time.

"Jonathan D" wrote:

I have a timetable that needs to have dated columns but I don't want to
create 52 work sheets for each week and each year have to change them all.

Is there anyway to create a macro to print 52 pages with correct dates and
all starting from Monday to Sunday

Thanks