Access of excel macro to create multiple excel / access files based on a cell /...

S

Sam

New member
...column value within the file? Hi i have a large 50k file in Excel (.csv). There is a column with 100 distinct values in it. I would like to know if there is an excel macro to split the file base on this value and so create 100 files from the 1 file. I would also like to define the file name of the output files and a summary report of the results if possible? You help would be much appreciated... thanks
 
Back
Top