Sheets for every week + start and ending date of the week

**wimexcel** · 11-29-2012, 12:47 PM

Hi,

I'm new to this forum, so I hope I do it correct

For my school, I have to make a week schedule in excel with a sheet for every week of the year.
Each sheet is named after a week. In every sheet the weeknumber + start and ending date must be mentioned.

Now I use a list with all the weeks + start date and ending date of that week.

Please Login or Register  to view this content.

I can't find a way to input the start and ending date automatically.

Also, I'd like to make it without the list. A student will only have to input a a starting date and ending date. Excel will then automatically generated the weeks/sheet in between.

Is there a solution for this?

Thanks for your help

**xLJer** · 11-29-2012, 06:12 PM

You may be able to work with this and edit to suit your needs.
After receiving input for starting and ending dates, it copies the
scheme worksheet into weekly sheets named after the week number plus
starting and ending dates for the week, Sunday through Saturday.

A file is attached. When testing you can quickly delete all the sheets you've created
by (1) clicking on the first tab to be deleted, (2) scroll to the last tab to be deleted,
(3) hold down the shift key and click the last tab (4) right-click the last tab and choose Delete.

Please Login or Register  to view this content.

**wimexcel** · 11-30-2012, 05:51 AM

Hi xLJer,
Thanks for your help. Looks like a great solution for my problem. When testing your file for one month I get an error:

"An unexpected error occured
6 overloop"

**xLJer** · 11-30-2012, 01:48 PM

Look at the code in my previous post. There are 4 lines that have red font.
Make these changes to the code in the worksheet module.
As an alternative, you could copy and replace the whole procedure.

What is different is that the loop that copies sheets runs for the number of
weeks between start date and end date, and does not compare dates to end the loop.