+ Reply to Thread
Results 1 to 4 of 4

Automatically Creating Workbook Files from Worksheet Data

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Automatically Creating Workbook Files from Worksheet Data

    Automatically Creating Workbook Files from Worksheet Data
    I copied the VBA code from the link above that creates new workbooks based on the contents of the Master worksheet from msdn.microsoft web site

    The code for this solution assumes the following:
    The master worksheet that contains the list of region names is named REGION SHEET.
    The first three rows of the master worksheet contain boilerplate information that will be copied to each new workbook.
    The list of region names is in column B of the master worksheet, and the first name in the list is in cell B4.
    The row for each region contains additional information that will be copied to the new workbook for that region.
    Column A Column B Column C Column D
    Row 1 Information 1
    Row 2 Information 2
    Row 3
    Row 4 Region: North Reprentative: Peter
    Row 5 Region: South Reprentative: Paul
    Row 6 Region: East Reprentative: Steve
    Row 7 Region: West Reprentative: James

    Running the macro on this data should create four workbooks named North.xlsx, South.xlsx, East.xlsx, and West.xlsx. Each workbook should contain the first three rows of boilerplate data, followed by the row of information for that region.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,057

    Re: Automatically Creating Workbook Files from Worksheet Data

    So?

    What do you require of this forum?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Automatically Creating Workbook Files from Worksheet Data

    When I run the macro, it is not working.
    I want to adopt the VBA for another massive spread sheet which I am using at my workplace.
    Can some expert edit the code and make it to work PLEASE

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Creating Workbook Files from Worksheet Data

    Maybe:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating New Worksheet From Appending Other Worksheet Data in Same Workbook
    By ApexDave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 11:29 AM
  2. Replies: 1
    Last Post: 02-10-2014, 09:13 PM
  3. Extracting data from multiple .xls files in folder and creating new workbook
    By haedyr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2013, 07:28 PM
  4. [SOLVED] Automatically copying a data into another worksheet in same workbook
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-20-2012, 10:30 AM
  5. Replies: 1
    Last Post: 08-05-2010, 11:05 AM
  6. Replies: 11
    Last Post: 01-03-2009, 06:29 PM
  7. Updating files automatically using data from another workbook
    By Andrew Hicks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2007, 10:22 AM

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