Creating multiple files from a file based on field contents

[charbomb]

I'm looking to automate a process of separating an excel file into multiple files based on a columns contents. I then want to have those files saved as a csv. file using the field name as the file name. Can anyone help me?

Thanks

[watersev]

hi, charbomb, please save attachment. Save it to any folder of your choice, open it and run code "test", it will create three .csv files under the path of this workbook with the names of the columns. Hope this helps.