how to create a new sheet with today's date

  • Thread starter Thread starter mangesh
  • Start date Start date
M

mangesh

I have a worksheet, the first sheet is “template”, everyday I righ
click on it and click on create a copy and rename that sheet wit
today’s date. Now what I want is whenever I right click on “template
and click on create a new copy it should create a new sheet wit
today’s date (mm/dd/yy/).

Can anyone please help me out.
Thanks in advance
 
Hi mangesh

You can create a macro to do this and assign it to a button on the sheet

Sub test()
Sheets("template").Copy after:=Sheets(Sheets("template").Index)
On Error Resume Next
ActiveSheet.Name = Format(Date, "mm-dd-yy")
On Error GoTo 0
End Sub

You can not use the / in the sheet name
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
How to use Today's date in a cell and make it stay the same date 6
Macro to create new sheet 5
Combo Box Showing Date Selections 2
Excel Message box with days of month & date. 1
Questions concerning VBA coding 5
Excel Macro to copy a row to another sheet based on date 0
rename worksheet 4

Back
Top