Need Export Macro to text file based on email address

First off, completely brand new to all of this. I have been given the task at work to break down a csv file that is a dump of multiple users address books, and sorts them out according to the owner of the address books email addresses. What I'm looking to do is create a macro that would be able to distinguish a change in email address, and make a new file when it notices the change. Example:

A B
[email protected] Data
[email protected] Data
[email protected] Data
[email protected] Data
[email protected] Data


Ideally, I would like to create a file with the [email protected] rows only in one file, followed by [email protected] in another file, using the same macro if possible. Also, I'd like to try to name the newly created txt file the name of the email address in column A Not sure if this is even something that can be done, but I figured I'd take the shot considering the Excel file I have has over 300 address books and 6000 columns. I have been researching this for over the past 24 hours, and figured I'd finally wave the white flag and ask for help to see if it's even possible. Thanks in advance for any advice or suggestions!

This is fantastic. Thank you so much!!!! It worked great on the example file you had. This is what the file looks like that I have. I have already consolidated all of the address book data into column A. So it looks like this;

[email protected] Rose|Rose|Last Name|[email protected]|
[email protected] John|John|Doe|[email protected]|
[email protected] Jane|Jane|Doe|[email protected]|

Each address book entry is an individual row in the workbook. Some only have one, some have 50+
This format of Column B is exactly what I need to be dumped into the text file as is. This will allow my import of the address books to be seamless. I really appreciate your help. I thought this was a lost cause, you are awesome!

I'm trying to figure it out right now, but I feel like I'm breaking more then I'm fixing. If you have time to help, I would love it. If not I'll continue to grind away and see if I can figure out how to get this to do what I want.

Sample.xlsx


Here is a snippet

That's correct. I'd like it to stay in the exact format that it's in for column B. Thanks for all of your help!

You have made this a very Merry Christmas for myself. I thought this would take up the next week or two sorting through this. I cannot begin to thank you enough. I hope you and your family have a Happy Holidays and thanks again!