Filter to separate files

February 17th, 2013 by jeff full jeff full

I need to take a file and for privacy reason, break it into separate units. It takes forever to run them individually or even run it as one and then cut , paste into separate files. Is there a way I can filter data by a value in one column, take the corresponding data and break it out into separate files?

One Response to “Filter to separate files”

  1. admin admin Says:

    The best way to do this is to record a macro and run it when you need to separate the files. You must follow the following steps to make sure that your macro is successfully recorded:

    1. Activate auto-filter.
    2. Filter the data according to your criteria.
    3. Copy the entire worksheet by selecting the box above the row number 1 and the left of Column A, and click Copy.
    4. Open a new workbook.
    5. Select A1 in the new workbook.
    6. Paste the data into the new workbook.
    7. Save the file.
    8. Close the newly created file.
    9. Repeat Step 2 to 8 until you are done.

Leave a Reply

You must be logged in to post a comment.