Copy Sheets from a template

Hello-

I have a workbook in which I have a sheet labeled "Week 1" and a hidden sheet labeled "Template." The user enters a beginning date and an end date in a dialog box. I am using a date format, "ww," to determine the number of weeks between those dates. I then subtract the one week out to account for the "Week 1" sheet. I need to take that integer and create a loop to copy the hidden template sheet that number of times. The desired result is a workbook with tabs labeled "Week 1" through "Week x," determined by a beginning date and an end date. It looks something like this but I don't have it in front of me.

Please Login or Register  to view this content.

Any help is appreciated. Thank you.

I have added Code tags rhis time . Please read the Forum rules & use them in all future pots that require them.

Changing the Format will not return the week number. VBA does not support the WEEKNUM function so you need a UDF. place this in a Standard module

Please Login or Register  to view this content.

For the userform

Please Login or Register  to view this content.