Ok here is my delema. Every new day I have to create a new sheet tha
lists todays information for my team. All I do is copy one of th
previous sheets to the corresponding day. For example on Mondays w
have different things to do than on Thursdays so I would copy th
Monday sheet from the previous week and paste it into the new workshee
and clear out the old data. Then we would enter the new data and sav
the new sheet as that days date.

So my question would be is there a way to have it automatically creat
a new sheet for me according to what the day was. I would mak
templates labeled Monday through Friday.

-TyeJae

--
Message posted from http://www.ExcelForum.com

Nevermind I figured out how to do it with a button.

Thank

--
Message posted from http://www.ExcelForum.com

Worksheets.Add.Name = Format(Date, "dddd")

--
HTH

-------

Bob Phillips
"TyeJae " wrote in message
...
Ok here is my delema. Every new day I have to create a new sheet that
lists todays information for my team. All I do is copy one of the
previous sheets to the corresponding day. For example on Mondays we
have different things to do than on Thursdays so I would copy the
Monday sheet from the previous week and paste it into the new worksheet
and clear out the old data. Then we would enter the new data and save
the new sheet as that days date.

So my question would be is there a way to have it automatically create
a new sheet for me according to what the day was. I would make
templates labeled Monday through Friday.

-TyeJae-


---
Message posted from http://www.ExcelForum.com/