Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a need to generate a spreadsheet (timesheets for recording time) that
will do the following: 1. Create a worksheet in the spreadsheet that has as the date in the worksheet the date from the previous worksheet plus one day (incremental adds the next day's timesheet). 2. Name the worksheet the date. So if the date in say cell A1 was 2/10/10 the name of the worksheet would be something like 2-10-10 or 2/10/10. 3. As an added wish, I'd like to be able to tell the system how many days I want and what the starting date would be. So if I told the system to start on 2/1/10 and that the number of days to setup was 28, I'd get a spreadsheet with all of the 28 days of February as individual worksheets in my spreadsheet and the date of each worksheet would be a particular day in February and the name of each worksheet would be that day. I am not sure whether this is even possible since I am not an expert in programming Excel, but figure someone out there would know if it is possible and if possible how I can program the system to do what I am proposing. -- Thanks. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rename new worksheet with the current date | Excel Programming | |||
Function to insert current filename into worksheet? | Excel Worksheet Functions | |||
I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
Go to current date upon opening Worksheet | Excel Programming | |||
Help with Macro or VBA script - Insert current Time/Date for different records | Excel Programming |