That can be a bit confusing but I'll try to explain. I have been naming the
sheets to represent the drivers work week which starts on Thurs and ends the
following Wed. So for example Mar 3 - Mar 9 would be one sheet then Mar 10 -
Mar 16 would be the next and so on. Our weeks are based on the school
calendar week starting with the first day of school Sep 2 - Sep 8.
Hope this makes sence.

"JulieD" wrote:

> Hi
>
> yes, this can be done via VBA, however, if you'ld like to let us know how
> you would like your 42 sheets named we can incorporate this in the code.
>
> Cheers
> JulieD
>
>
> "dvonj" wrote:
>
> > I have just completed working on a sheet and now need to make copies of it. I
> > know I can right click on the sheet tab and select copy however I need 42
> > sheets. Is there a way to program XL to create 42 copies of the worksheet. I
> > am not real familuar with VBE but with help can work through it.
> >
> > Thanks