Break Data in to Multiple Excel Files – How to Video

About this tutorial:

Video duration: 13:59

Learn how to break data in to multiple Excel files in this tutorial using Excel VBA & Advanced Filters

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

23 thoughts on “Break Data in to Multiple Excel Files – How to Video

    Anchal Gupta

    (June 30, 2018 - 3:23 pm)

    Hi, This is a great video. I was looking for this splitting content. I found you used Extract range to copy the filtered data and then saved, however, if I don't want that rather copy within same cells and save. How would the code change? can you please help? Thanks.

    pradeep singh

    (June 30, 2018 - 3:23 pm)

    Thanks worked like charm on my file having 700,000 rows branches 104 and file over 50 MB.

    pradeep singh

    (June 30, 2018 - 3:23 pm)

    can you share the script

    Daniela Valdevenito

    (June 30, 2018 - 3:23 pm)

    Hello, how can I save the file with more than one criteria?

    Paras Goel

    (June 30, 2018 - 3:23 pm)

    You sir, are a magical genius! Thank you for gracing us with your presence!


    (June 30, 2018 - 3:23 pm)

    Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value in front of that….

    Richard Masilang

    (June 30, 2018 - 3:23 pm)

    Good day, can you help me in how to break data from different category in a list

    Camill Corsinie

    (June 30, 2018 - 3:23 pm)

    I am trying to use specific columns so as to create new worksheets.

    Anubhav Gupta

    (June 30, 2018 - 3:23 pm)

    Very good dear.. i am really so much happy..

    can you help me with one more thing with? you have filtered the data at Salesman level but if i want with Salesman and Month level data then how will be done?


    Mahmoud Hamed

    (June 30, 2018 - 3:23 pm)

    Thanks for this helpful video

    but If I need to delete the salesman column in the extracted file and also the header row, how can I do it.

    if you can help me in this issue it be great.

    thanks again.

    Joris Vanderlinden

    (June 30, 2018 - 3:23 pm)

    Great how-to! Thanks a lot!

    Karalapati Preethi

    (June 30, 2018 - 3:23 pm)

    nice video. can i send the joseph excel sheet to joseph folder which is in another location

    Harry Cummins

    (June 30, 2018 - 3:23 pm)

    Perfect for our needs. Thank you for sharing!

    jay kamdar

    (June 30, 2018 - 3:23 pm)

    Thanks for sharing the video. While I was trying to break data into Multiple txt files, this video was very helpful. I just changed the following code-
    the ActiveWorkbook.SaveAs Filename:=curPath & cell.Value & ".txt", _

    It did convert my files to txt. However, when I open it…The words are not Emglish like..they seems to be some characters or encryption looking of some kind.
    Your help is greatly appreciated.

    Joan Black

    (June 30, 2018 - 3:23 pm)

    Awesome of you to share.  Worked  like a charm the first time.  Thank you very much.


    (June 30, 2018 - 3:23 pm)

    awesome video! But how do you extract it?

    Ludvig Borga

    (June 30, 2018 - 3:23 pm)

    Fantastic Video.  This really helped me solve a problem I was having at office with extracting data from a central database.  I will definitely be visiting your website for more tips and tricks.  Cheers!

    Eric Soetrisno

    (June 30, 2018 - 3:23 pm)

    hi, how can I add the "extract" button shown in the file? I've finished setting up the formula but cannot complete doing the refresh. Could you please let me know how? Thank you.

    Ravi Surolia

    (June 30, 2018 - 3:23 pm)

    this is amazing , I was searching from long and today I got it, you having really amazing expertise sir….


    (June 30, 2018 - 3:23 pm)

    Hi, this is excellent.  Can you show how to break into multiple tabs on the same workbook?

    Dawn H

    (June 30, 2018 - 3:23 pm)

    This is super helpful. One question I have. Is there way to add report titles to the top of the report?

    Brett Bingham

    (June 30, 2018 - 3:23 pm)

    Can you attache the module code?

    Driss HAFFAD

    (June 30, 2018 - 3:23 pm)

    EXCELlent 😀

Leave a Reply

Your email address will not be published. Required fields are marked *