Solved

Copy an existing worksheet and create the same worksheet worksheet for each day of the year

Posted on 2011-03-13
3
226 Views
Last Modified: 2012-05-11
Hi,

I have a worksheet prepared in Excel for the Cashiers that needs to be prepared on daily basis. I am interested to copy that worksheet and have it prepared for each day of the year in the same workbook. But it will be time consuming if I do it manually.

I know that with macros I should be able to do that, but I don’t have any idea how to prepare it.
It would be perfect if the sheets are named as dates, for example: 3/1/2011, 3/2/2011, 3/3/2011 or it could be March 1 2011, March 2 2011.

Please let me know if you have any questions.

Thanks and Regards,

Michael
0
Comment
Question by:mmoralespr
  • 2
3 Comments
 
LVL 8

Expert Comment

by:wchh
ID: 35124427
try Macro Below
Sub Macro1()

Dim datefr As Date
Dim cnt As Integer

datefr = Now()
For cnt = 1 To 10
    datefr = datefr + 1
    Sheets("Template").Select
    Sheets("Template").Copy After:=Sheets(cnt)
    ActiveSheet.Name = Format(datefr, "mmm d yyyy")
    Next
End Sub

Open in new window

0
 
LVL 8

Accepted Solution

by:
wchh earned 500 total points
ID: 35124438
For Full Month Name,
ActiveSheet.Name = Format(datefr, "mmmm d yyyy")
0
 

Author Closing Comment

by:mmoralespr
ID: 35124581
Thanks wchh, it worked perfectly. I appreciate your help.

Take Care,

Michael
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question