excel - How can I iterate through a worksheet and export groups of cell ranges to individual CSV files?

Question

I have a large dataset (13292 rows, 96 columns) which contains data for ~100 different groups (group1, group2, etc.).

How can I iterate through the dataset and export each group into their own CSV (including headers)?

For example, every record which has group1 listed against it would be exported to group1.csv and so on.

Is there a quick way to do it? VBA-based suggestions are also welcome.

question from:https://stackoverflow.com/questions/65848673/how-can-i-iterate-through-a-worksheet-and-export-groups-of-cell-ranges-to-indivi

Answer 1

Waitting for answers