Macro to create and delete week sheets

[Morre]

Hi

I have a file with 52 sheets. 1 for each week where i fill in data. Now i want to write some code that creates every week a new sheet with the weeknumber in the name and delete the week before the current week.

Any help or threads where i can find the awnser.

thnx

 

[jammer12001]

Are you just trying to eliminate scrolling through 52 sheets?

 

[Morre]

my purpose is when the file opens it deletes cur week -5 and takes a copy of a blank week sheet and copies it to the end of the workbook and renames it to the previous delete week sheet.

Exmpl

User opens file
"Week 10" is delete in the beginning of the file. Next copy of sheet "week_blank" to the end and rename "week_blank" to "Week 15"