Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to create a new sheet with today's date
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Todays date | Excel Discussion (Misc queries) | |||
calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
today's date in excel | Excel Discussion (Misc queries) | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |