Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need to split up Excel File to multiple CSV files bases on column

  Asked By: Dale    Date: Jan 26    Category: MS Office    Views: 1485
  

I have an Excel file looking like:

DocName|ArchiveBoxNumber|Description

I need to get the DocNames for each ArchiveBoxNumber and save it to a
csv with the ArchiveBoxNumber as the filename.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Aylin Kaya     Answered On: Jan 26


Do you have 1 ArchiveBoxNumber for 1 DocName or there could be
multiple DocName for the same ArchiveBoxNumber? I have done
something similar recently so probably I could provide some help.

 




Tagged: