+ Reply to Thread
Results 1 to 5 of 5

Newbie, need help with Macro to duplicate template sheet

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Question Newbie, need help with Macro to duplicate template sheet

    First off, I am extremely new to VBA so I appreciate any help I can get. Here is what I am trying to do.

    I have a workbook with one sheet (Template). I would like a macro to create duplicate copies of the (Template) sheet and name each of the new sheets using the following naming format. ("dd-mmm-yy"). I have a macro that will create the new user defined sheets which I like, however, I don't have a clue how make it also copy the contents including the formating to the newley created sheets. Would anyone be willing to help me out? Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Newbie, need help with Macro to duplicate template sheet

    This is what you are looking for?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Newbie, need help with Macro to duplicate template sheet

    Yes, that is exactly what I had asked for. Is there a way to perform the same thing without copying the the form control button to all the sheets?

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Newbie, need help with Macro to duplicate template sheet

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-26-2012
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Newbie, need help with Macro to duplicate template sheet

    PERFECT!! Thank you for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1