+ Reply to Thread
Results 1 to 2 of 2

Create new Excel file based on category

  1. #1
    Registered User
    Join Date
    01-06-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    1

    Create new Excel file based on category

    ONE Data1 Data2 Data3 Data4
    TWO Data1 Data2 Data3 Data4
    THREE Data1 Data2 Data3 Data4
    TWO Data1 Data2 Data3 Data4
    TWO Data1 Data2 Data3 Data4
    ONE Data1 Data2 Data3 Data4


    With the example above as reference my goal is to take from one file that contain all the data I'm working with and create new files based on data in a given cell that I'll refer to as category.

    So... With the data above I would end up with 3 new excel files ONE.xls, TWO.xls, and THREE.xls. In those new files they would contain the data in the rows with the corresponding category.

    Thanks for looking at my post.
    Jesse

  2. #2
    Registered User
    Join Date
    10-06-2003
    Location
    Ashford, Kent - Working in London
    MS-Off Ver
    2016
    Posts
    95
    Hey Jcolby,

    Try posting again in the Programming secion. You'll need a macro, so that's where to get the help.

    Cheers,

    Chris.
    Jcolby,

    No need to repost as a Mod has moved it
    Last edited by VBA Noob; 01-19-2009 at 02:41 PM. Reason: Moved to programming
    Big Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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