+ Reply to Thread
Results 1 to 3 of 3

Split Macro modification to Split into new Workbooks instead of sheets within one workbook

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    North Carolilna
    MS-Off Ver
    Excel 2007
    Posts
    20

    Split Macro modification to Split into new Workbooks instead of sheets within one workbook

    I have a macro that splits data into separate sheets within the workbook based on a specific field. I now need to split into separate workbooks based on that field instead of into separate sheets.

    Many thanks to Ron deBruin for the original macro and Alphafrog for the assistance in customizing it for my needs.

    I tried searching the forum for possible solutions, but couldn't come up with the right keywords to narrow the search down from the 1000+ results.

    Can someone tell me how to modify this and/or point me to a macro that is already set up to do this?

    Thanks in advance!



    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by arlu1201; 06-26-2012 at 11:35 AM. Reason: Use code tags in future.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Split Macro modification to Split into new Workbooks instead of sheets within one work

    'ONE SHEET to WORKBOOKS (1)
    Here's a macro for taking a sheet with data and creating individual wbs from each unique value in a chosen column. The date is added to the workbook names to give a reference as to when the wbs were created.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Split Macro modification to Split into new Workbooks instead of sheets within one work

    How'd that work for you?

    If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.

+ 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