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:

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