LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,814
Default Macro to Insert Worksheet with Worksheet Name the Current Date

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename new worksheet with the current date Jeff Parrott Excel Programming 5 December 30th 08 07:51 PM
Function to insert current filename into worksheet? Ginko Excel Worksheet Functions 2 May 7th 08 12:32 PM
I can't insert a worksheet into my current spreadsheet file John Falkenstine Excel Worksheet Functions 3 October 10th 07 01:24 AM
Go to current date upon opening Worksheet Jason Excel Programming 6 August 21st 06 01:41 PM
Help with Macro or VBA script - Insert current Time/Date for different records [email protected] Excel Programming 5 June 8th 05 03:37 PM


All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"