Results 1 to 2 of 2

Need vba code with in 10line Split Into Separate Wkbooks Based on Values In a Specific Col

Threaded View

breadwinner Need vba code with in 10line... 04-06-2015, 02:10 PM
JBeaucaire Re: Need vba code with in... 04-06-2015, 02:56 PM
  1. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need vba code with in 10line Split Into Separate Wkbooks Based on Values In a Specific

    Your request is a common one... split one sheet of data out to separate workbooks using the values in one specific column of that primary sheet. It is NOT only 10 lines of code, so you will have to buckle down and examine one of the many turn-key solutions available on the web. Here's my published solution:
    ------------------------------
    'SHEET1 TO MANY WORKBOOKS
    Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values in that column.My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.
    Last edited by JBeaucaire; 12-26-2019 at 04:20 PM.
    _________________
    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!)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split Data based on 3 Columns into separate worksheets
    By angeleenmc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-29-2014, 12:40 PM
  2. VBA code to split a worksheet into separate excel files.
    By sambo24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 06:15 AM
  3. [SOLVED] How To Split Excel File Into Separate Workbooks Based on Values In a Specific Column
    By UzieJacuzzi in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-31-2012, 07:26 AM
  4. [SOLVED] Split table, based on two criteria, into separate workbooks
    By gingert88 in forum Excel General
    Replies: 6
    Last Post: 07-10-2012, 06:08 PM
  5. Replies: 3
    Last Post: 01-13-2012, 08:20 AM

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