asked on 9/14/2016

VBA to change Sheet names

I have a ‘Template’ spreadsheet with 31 tabs, 1 for each day of the month. At the beginning of each month we have to create a new file with each tab having the current months dates . Could an expert provide me with VBA code that will change each TAB to the current months dates.

i.e. For Sept we have 1 Sept 16, 2 Sept 16 etc so when we go into Oct we would need 1 Oct 16, 2 Oct 16 etc

Would it be possible to have a ‘pop-up’ that could ask “what month do you want to create” that would enable us to create the file prior to month end.

Also I need to clear any data in cells A3:L? and N3:R? [? Means all data below] on each one of the sheets with a date on.

Many thanks in advance

Microsoft Excel

Last Comment

Rob Henson

9/15/2016

ASKER CERTIFIED SOLUTION

Rgonzo1971

9/14/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Rob Henson

9/14/2016

If this is being run from a template, can the template have just one sheet to copy the required number of times? Columns A and N on the template sheet can then be blank to start with.

Thanks
Rob

Jagwarman

9/14/2016

ASKER

Rob that is what they do today and seem to mess it up so I prefer a macro that will create the month for me. But thanks anyway.

Jagwarman

9/14/2016

ASKER

Rgonzo, thanks for that it works great.

Jagwarman

9/14/2016

ASKER

Always delivers thanks

Rob Henson

9/15/2016

I was suggesting that you start with a single sheet template file from which you run a macro that creates a file with the correct number of sheets based on the template sheet.

Thanks
Rob H