Save Multiple Files from Data in ONE sheet

[rmoran4446]

Hello, and thank you in advance for any help.


I have a sheet with a LOT of data in it. I am looking to export/save a .csv or .xls file based on a change in column values.

For Example: I would want 1 csv for J Todd Foster, 1 for Loran J Marmes, 1 for Matthew Atkinson, etc....

The seperate saved files should also include the header row.

The File name could just be AgentName.Timestamp


Example Table:

Writing Number	Agent Name	Subscriber Number	Month Paid	Effective Date	Member Count	Premium Received	Commission
300699	J Todd Foster	MB01336064	17-Jan	17-Jan	1	383	16
300699	J Todd Foster	MB01334644	17-Jan	17-Jan	1	338	16
300699	J Todd Foster	MB01337972	17-Jan	17-Jan	1	358	16
300693	Loran J Marmes	MB01334372	17-Jan	17-Jan	1	695	16
300693	Loran J Marmes	MB01313949	17-Jan	17-Jan	1	0	16
300693	Loran J Marmes	MB01337320	17-Jan	17-Jan	1	751	16
300693	Loran J Marmes	MB01335937	17-Jan	17-Jan	1	964	16
300842	Matthew Atkinson	MB01337089	17-Jan	17-Jan	1	311	16
300842	Matthew Atkinson	MB01337887	17-Jan	17-Jan	4	659	64
300927	Richard Melberg	MB01326916	17-Jan	17-Jan	2	911	32
300694	Ryan Moran	MB01337866	17-Jan	17-Jan	1	224	16
300697	Scott W Lange, Jr.	MB01337841	17-Jan	17-Jan	1	362	16

<tbody>
</tbody>