Creating a new sheet
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 |
Creating a new sheet
Nevermind I figured out how to do it with a button.
Thank -- Message posted from http://www.ExcelForum.com |
Creating a new sheet
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/ |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com