Sort, Filter, and Split Excel File into a Series of Sub-Files

Question

Hi,I have a large spreadsheet of product data with ~120,000 rows of products and 1364 columns of product attributes (features).&nbsp;What I need to do is:1. Split the data into new files by top level category (the first part of the string in 'category', column G, before the "/") - copying the header data across too.2. In each new subfile delete columns that have no data under the header row (most of the 1364 columns will now have no data)3. Save the subfiles as a sequence, e.g. Spaice_001.csv, Spaice_002.csv.Can anyone help with a macro or script that will do this for me?thanks,&nbsp;Vipul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

See Create a new workbook for all unique values
It shouldn't be hard to modify the code to create .csv files instead of workbooks.

Forum Discussion

Sort, Filter, and Split Excel File into a Series of Sub-Files

Resources