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