• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Split data into multiple worksheets based on column and export to csv files

J

jk51

Member
Hi,

How to split data into multiple worksheets based on key column and export to individual files in csv using excel 365?

Thanks

Mr Singh
 
Hi !

Use a filter or an advanced one, copy to a new worsheet or workbook then Save as feature …
​
 
Thanks Marc L, Ali.
Keen on automation using VBA or macro with Excel 365. Does anyone know script on how to split data into multiple worksheets based on key column and export to individual files in csv ?

Mr Singh
 

Exactly what I previously wrote even for an automation and don't forget the Macro recorder …
​
 
You must log in or register to reply here.
Back
Top