Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Split Workbook into Separate Workbooks VBA

  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10

    Split Unique Data into Multiple Workbooks

    Hi All,

    Might be a useful one ....

    Note: The file uploaded.
    Attached Files Attached Files
    Last edited by Admin; 08-18-2012 at 10:07 AM. Reason: Upload file with edited code

  2. #2
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    13

    Lightbulb Split Workbook into Separate Workbooks VBA

    Kris
    It is cool all the various programs you & Fox are putting up - in this latest one i changed the output folder (Cell C10) - however the output files still are save in my apps.path - I just figured I could change settings on the sheet itself - and it would save it in that folder.
    xl2007 - Windows 7
    xl hates the 255 number

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Edit: New file uploaded.
    Last edited by Admin; 08-18-2012 at 10:08 AM.

  4. #4
    Junior Member
    Join Date
    Sep 2011
    Posts
    13
    Rep Power
    0
    Dear Kris,

    This is really a good one which is useful for our daily works.

    Regards
    R.Ramakrishnan

  5. #5
    Junior Member
    Join Date
    Apr 2012
    Posts
    4
    Rep Power
    0

    split with multiple condition

    HI admin,

    I require a similar kind of macro to split data into multiple workbooks but with 3 conditions.

    Ex column A to E have the data.

    A is supplier name
    B is supplier's region
    C is Currency
    D is Product.
    E is amount

    Here in A I will have different suppliers who are from different region however there is a chance that supplier name could be same in different region. When the country changes the currency also would change

    Hence I need a macro to create multiple workbook for the below filtering criterias

    Supplier Name
    Supplier's Region
    Currency

    Hope you could help me.

    Regards,
    Malai

  6. #6
    Junior Member
    Join Date
    Mar 2014
    Posts
    1
    Rep Power
    0
    Quote Originally Posted by Admin View Post
    Hi All,

    Might be a useful one ....

    Note: The file uploaded.
    Wonderfully programmed piece of code guys ! thank you for putting that up. could you please advise as to what line of code and where I would add it so as to ensure that the newly split files retain the formatting of the original ?

    All help appreciated, many thanks !

  7. #7
    Junior Member
    Join Date
    Dec 2015
    Posts
    1
    Rep Power
    0
    Great macro.
    Is there perhaps one that can filter multiple columns? (2+)
    Date - Unique Field A - Unique Field B

  8. #8
    Junior Member
    Join Date
    Feb 2016
    Posts
    2
    Rep Power
    0

    Based on value in list Past normal or transpose

    Hello,

    This is really a great script.
    Tis is helping me out. what a power to get things arranged.
    I have one question.
    Do you think it is possible to have in the default example (The XLSM file)
    To Add a column that contains a value V (Vertical) the output is paste in a new workbook Vertical (Transpose)
    So that I in the ControlSheet can select the column that contains the past direction.
    And a second one that contains the value that is in the column for the past direction. If it is True, it will be passed in the new Workbook but then transponse.

    16-02-16 20-22-02.png

  9. #9
    Junior Member
    Join Date
    Feb 2016
    Posts
    2
    Rep Power
    0

    Paste Transpose (based on vaule in column)

    Hello,

    SplitDataIntoMultipleWorkbooks.xlsm is realy a great excelsheet and woorks good.
    For me it would be nice to have a extra feature and that is, to have the output (Workbooks) based on a selected Column, and A true or false value, Past in Transpose.

    It would be nice to select on the Controlsheet, the column that holds the value that decides if the workbooks are created normal or in transpose.

    Selectie.jpgTranspose.jpg

    Kind regards,

    Alex

  10. #10
    Junior Member
    Join Date
    Mar 2016
    Posts
    1
    Rep Power
    0
    Hi, thanks for the sharing.
    but wonder if there possible to split the workbook according to number of row with column (example: A5)
    as my filter header was on row no 5. Row 1 till 4 was the workbook header such as Company name, report name etc.

    Anyway appreciate your sharing

Similar Threads

  1. Replies: 4
    Last Post: 06-18-2013, 01:38 PM
  2. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  3. Replies: 2
    Last Post: 12-19-2012, 08:28 AM
  4. Replies: 12
    Last Post: 08-19-2012, 06:17 PM
  5. Split Closed Workbook into Multiple Workbooks Using ADO
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 10-02-2011, 08:34 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •