+ Reply to Thread
Results 1 to 3 of 3

Creating New Worksheets based on a list of names

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    85

    Creating New Worksheets based on a list of names

    Hi,

    I am trying to
    1)create multiple worksheets based on a names from a the worksheet "Names".

    2)The source of the copying is from the work named "Copysource".

    3) In addition, I want the worksheet names of the sheet to be based on the Names sheet and also for every of the new worksheet cells(1,2) to have the worksheet name also

    here is the code i have so far

    Please Login or Register  to view this content.
    thanks for anyone helping in advance

    Mod. edit: CODE rather than QUOTE tags please
    Attached Files Attached Files
    Last edited by kchm_2000; 04-25-2011 at 06:47 AM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Creating New Worksheets based on a list of names

    hi, kchm_2000, please check attachment, press "Start" button
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-22-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: Creating New Worksheets based on a list of names

    thanks a lot

+ 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