+ Reply to Thread
Results 1 to 2 of 2

How to save specific data into multiple files

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    veghel, netherlands
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to save specific data into multiple files

    I recently posted this issue in a different forum. However, nobody seems to be able to help me over there.

    I would like to have some help with the following. I have a large file with different customers. I.e.:
    name, email, phonenumber, branch, country

    Now I would like to save name, adress and zipcode in one CSV file for each branch in each country.
    For example:

    Google, [email protected], 012354563, internet, US
    UPS, [email protected], 012345631, delivery, NL

    would result in 2 files:
    somename_us_internet.csv
    somename_nl_delivery.csv

    Can somebody please help me with this?

    the link with the other forum is http://www.ozgrid.com/forum/showthread.php?t=154859 ; I'm just telling you this so you don't waste your time if the problem is already fixed. Of course, I will tell the solution here too when I have it.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: How to save specific data into multiple files

    If your data are in data.csv
    and the path is "E:\OF\"

    Please Login or Register  to view this content.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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