how to create a new sheet with today's date

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"mangesh" <mangesh.24tupa_1142621401.8786@excelforum-nospam.com> wrote in message
news:mangesh.24tupa_1142621401.8786@excelforum-nospam.com...
>
> I have a worksheet, the first sheet is "template", everyday I right
> click on it and click on create a copy and rename that sheet with
> 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 with
> today's date (mm/dd/yy/).
>
> Can anyone please help me out.
> Thanks in advance.
>
>
> --
> mangesh
>
>
> ------------------------------------------------------------------------
> mangesh's Profile: http://www.excelforum.com/member.php...fo&userid=6746
> View this thread: http://www.excelforum.com/showthread...hreadid=523691
>