sort & export selective records to new csv

I've attached an example of the original master file as well as the desired results file. The master file has column A with the "Plan" name. The attached file has 608 columns or "records", and when sorting the row alphabetically, you will see where there are sometimes only one record for that plan or multiple records with the same plan name. I'm needing to sort the records separately that are the same plan and save only those records as a new csv file. The resulting saved files I will then merge as variable data to a pdf for printing personalized statements. That part I have figured out, just need assistance with getting the records separated. Any suggestions?

Thanks in advance for your help.

I believe this is what you are seeking :

Please Login or Register  to view this content.

Thank you very much for looking into this. The Macros work with the exception of this error that occurs after creating individual worksheets within the file. I did debug and change the path however still receive this error. Screenshots attached. Any suggestions?

Your pictures are too small for me to read with any detail.

Hopefully these attached are legible

Hello Alan. First, thank you for your work on this. Yes I did test and receive the error in the above screenshots. It seems that once the first Macro is completed, the second Marco to save each worksheet as an individual file fails. I did try to debug and change the destination path, but have not gotten that to work. Any suggestions?

Did you first create a folder on your desktop named 'Test' ?