We have a spreadsheet with 12,000 rows on it. Each column is standard things like Name, Address, Phone, etc. The last column we'll call OWNER (I'm not sure on the exact name).

Every row has unique information for people who attended our event except the OWNER field. The owner field is the name of the person who sold the person their ticket.

So, the OWNER field could have one name in it 3 times, one name in it 50 times, one name in it 1000 times, etc.

END RESULT
What we need to do is break out the list into individual XLS files so that each OWNER has a file of the people that he sold tickets to.

Currently someone is going through the list, higlighting all the infor for each OWNER, cutting and pasting it into it's own file... This is going to take many many many hours to complete. Anyone have a way of automating this? The name of each XLS file could jsut be the same data as is in the OWNER field.

I'm just a beginner at Macros and such but if someone has somethign like this, PLEASE let me know ASAP.

Thanks!