+ Reply to Thread
Results 1 to 6 of 6

Create Multiple New Files from Master Sheet

  1. #1
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Create Multiple New Files from Master Sheet

    Good day - thanks in advance for your time. I'll be attaching a sample worksheet to help with what I'm probably not describing too clearly.

    I have a "master" file that needs to be parsed into multiple other files. The number of other files will vary daily, but I've identified the file number in Column A. So if on Monday there are only 3 files, the numbers in column A won't exceed 3.

    What I need to do is create and save 3 (or however many) new files containing ONLY the rows from the master with the associated file number in Column A. The filenames will be similar, but not the same, but I can set that up as a variable.

    I've tried using auto filter, and changing the values being read, but I can't reliably catch the correct file number from the top visible row.

    Can anybody lend me a hand?

    THANK YOU!!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Create Multiple New Files from Master Sheet

    not entirely sure what you are after
    attached is example with your data on how to autofilter based on Unique values in column A
    copy that filtered data into new sheet

    it sounds like you just want to copy into new workbook and save but im not quite sure but it seems like you know what to do from this point on wards
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Create Multiple New Files from Master Sheet

    Humdingaling - thank you so much for getting back to me. I apologize for the delay in response, but was called out of town somewhat unexpectedly and had no access to a pc.

    The autofiltering is great, and I certainly appreciate it. I think I can find code to copy the filtered values, create a new workbook, paste the results, then save to a repository and close. Once I get those things to work I'll be all set.

    Thank you again!

  4. #4
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Create Multiple New Files from Master Sheet

    Thanks again for your help...did a little tweaking and added some code for the saveas and I have what appears to work.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Create Multiple New Files from Master Sheet

    good to see you have come to a solution
    just a few comments about your finished code

    i would not call your column H combobox ....technically it is Data Validation (DV)

    also
    Please Login or Register  to view this content.
    this limits yourself...in case you ever do go over 50000 lines
    just good practice to start using rows.count (which you do use in other bits of your code)

    that aside you seem to have things under control

  6. #6
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Create Multiple New Files from Master Sheet

    Ah, thank you for the reminder about the Data Validation box... and for the rows.count correction. I generally don't hard code a number in there like that, but often do so as a placeholder while I'm writing/testing and just forgot to replace it. I know, it's easier to write rows.count, but old habits die hard I suppose!
    Anyway, thank you again for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Consolidating multiple sheets in master tab and create summary sheet
    By Farida in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2014, 02:41 PM
  2. Combining Data from Multiple Excel Files into One Master Sheet
    By glennchung in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-12-2014, 06:28 PM
  3. How to lookup vaues to create a master file from multiple daily files
    By j0nx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2013, 05:31 PM
  4. [SOLVED] Copy range from multiple files in multiple folders to single sheet in master WB
    By Royzer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-18-2012, 03:40 PM
  5. Create Multiple Sheets from master sheet
    By neilshaw in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-08-2011, 06:10 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