+ Reply to Thread
Results 1 to 5 of 5

Create new worksheest based on a list of names & Template

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Create new worksheest based on a list of names & Template

    Hi,

    I have some code that creates and renames new worksheets based on a list of cells in another sheet (Summary) . What i would also like is to have these new sheets to contain the information based in another worksheet called 'Template' rather than just being blank sheets. I've faffed around but can't seem to get it to do it properly. Help appreciated....


    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: Create new worksheest based on a list of names & Template

    What about using copy instead of "Add", like this:

    Please Login or Register  to view this content.
    Make sure that range("A1:A10") of sheet "Summary" is full of data.
    Last edited by Subverter; 04-25-2013 at 07:14 AM.

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Create new worksheest based on a list of names & Template

    Hi,

    That creates the sheets but doesn't rename them as per the list. They are just called 'Template 1, Template 2 etc....

  4. #4
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: Create new worksheest based on a list of names & Template

    Try this Example...
    Examp.xlsm

    idk if there's a difference between executing it in Excel 2010..
    Last edited by Subverter; 04-25-2013 at 09:07 AM.

  5. #5
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Create new worksheest based on a list of names & Template

    thanks that works fine. Is there any way the code can be changed so that I dont have to enter the range (A1:A10) in the macro itself and it just finds where the test in the column finishes automatically?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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