Solved

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

Posted on 2011-03-13
3
227 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

791 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