Generate worksheets that are named as dates

[jakefh]

Hi.

I've found some macros that nearly do what I want, but my non-existent vba knowledge means I cannot edit them to do what I want.

I have a worksheet that I want to duplicate onto new sheets and I want the tabs to be named after sequential dates. eg tab 1 would be "template", tab 2 would be "3/3/18", tab 3 would be "10/3/18" etc.

Ideally I would like to have a start & finish date.

I would also like to choose between it repeating every 7 days and every 1 day but I don't mind if this is two separate macros.

Thanks in advance.

 

[jakefh]

Perfect and very impressive

Apologies for not checking in sooner, we don't cope well with snow in the UK...

Thanks a bunch.

 

[My Aswer Is This]

Perfect and very impressive

Apologies for not checking in sooner, we don't cope well with snow in the UK...

Thanks a bunch.

Glad to see this works for you.