Add a new tab once daily

[malevolentmuse]

Hello there. New to the forum and just starting to delve deeper into Excel 2013, but I can't figure out how to do this for the life of me. I'm creating a monthly spreadsheet that will be tracking information daily, but I want to make it easier for everyone. Rather than the users having to add a new sheet each day or have a bulky workbook with 30 or 31 sheets from day one, I need a macro that will automatically create a new sheet each day, named for that day, but only do it once a day. Help!

[AlphaFrog]

This macro automatically runs when you open the workbook.
Put this code in the ThisWorkbook code module
It checks if a worksheet with today's date already exists and if not, it adds a new worksheet and names it.
Change the worksheet date name format (red) to suit.

Please Login or Register  to view this content.

[malevolentmuse]

Worked like a charm! Thank you so much!

[xladept]

Hi malevolent muse,

Try this in the "ThisWorkbook" module:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select "ThisWorkbook” from the Insert menu

Type "Option Explicit" then paste the code under it

and you're ready to roll

[malevolentmuse]

Hi xladept! Thanks for your code as well. That one will be well suited for another workbook I'm working on. I'm a busy boy. Thanks so much for everyone's help.

[xladept]

You're welcome!