Duplicate tab with new date

[lmoore123]

I have an excel sheet used to track employees who work OT daily. I want to create a button that will open a duplicate of the original (blank) in a new tab with the current date. Can that be done?

 

[mumps]

open a duplicate of the original (blank)

I assume that you don't want a totally blank sheet but to delete just the employee data? Is this correct? Do you want the new sheet to be named using the current date? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[lmoore123]

Yes, I want the template from the primary tab to copy into a new tab labeled with the current date. The employee data would be saved on the new tabs for each date, creating a record the supervisors could look back on. The original template would remain unchanged. Dropbox link below.

OT

 

[mumps]

Try this macro. Change the name of the sheet to be copied (in red) to suit your needs.

Sub CopyTemplate()
    Application.ScreenUpdating = False
    Sheets("Primary").Copy after:=Sheets(Sheets.Count)
    ActiveSheet.Name = Replace(Date, "/", ".")
    Application.ScreenUpdating = True
End Sub