Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocreate Worksheet
I'm wondering if there's a way to automatically create a worksheet based on a
new day. I have a workbook with a worksheet for each day that I'm on a job for my work. I have to copy the last day's worksheet and rename it to the next day, for example, "Day 1" becomes "Day 2". What I"m wanting to accomplish is to have a new worksheet automatically created at 12am each day that I'm on the job, and the worksheet name increment for the next day. Also, some of the functions are dependant on the previous day's values, so they would have to update as well. Is there a way to do this that isn't too complicated? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocreate Worksheet
I'm trying to do the same thing. Would you let me know how you can do this
when you get it done? See my post (Subject: new day in next worksheet Day 1 plus 1?) Reply follows. Sub bumpit() Sheets("Sheet2").Range("A1").Value = Sheets("Sheet1").Range("A1").Value + 1 End Sub -- Gary''s Student - gsnu200740 "Kevin" wrote: I'm wondering if there's a way to automatically create a worksheet based on a new day. I have a workbook with a worksheet for each day that I'm on a job for my work. I have to copy the last day's worksheet and rename it to the next day, for example, "Day 1" becomes "Day 2". What I"m wanting to accomplish is to have a new worksheet automatically created at 12am each day that I'm on the job, and the worksheet name increment for the next day. Also, some of the functions are dependant on the previous day's values, so they would have to update as well. Is there a way to do this that isn't too complicated? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Autocreate folders | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |