Automatically rename sheets with week and dates

Good day,

At work I've created a simple attendance sheet where i have the year and weeknumber in a seperate cells, and then for the different days it calculates the dates.
For every week there is a different worksheet, but now they're named manually with the weeknumber and start and end dates of that week as follows "Wk# | dd-dd MMM". This would look something like "Wk12 | 18-22 Mrt" for this current week (Mrt, because I'm Dutch). For a week overlapping months, it would then have the shorthand month behind each number like "29 Apr - 3 May" for example
Is there a piece of code I could use that would automatically rename the sheets like that based on the value in the cells I mentioned earlier?

Thanks in advance.

something like:

Please Login or Register  to view this content.

Hi there,

See if the following code does what you need (it renames individual worksheets, but can be easily modified to rename all worksheets if appropriate):

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by Greg M

Hi again,

Ok, here's the Bulk-Rename version, and (I hope) the date-crunching mechanics are a bit more straightforward!

Please Login or Register  to view this content.

Regards,

Greg M

This code works perfectly! Thanks. Got a mismatch error at one point, but solved that.
Would you also happen to know how to exlude certain worksheets from being renamed?

Regards,

Danny

Hi again Danny,

The highlighted additions should do what you need - obviously the sheet names should be altered to suit your requirements:

Please Login or Register  to view this content.

Glad to hear that the previous version got things moving in the right direction.

Regards,

Greg M