Hello, I've searched, but have been unable to find / figure out how to solve my problem. Any help would be greatly appreciated!
Each week I receive a new list and I need to break it up into several sub lists. The problem then comes that I need to sort the sub lists by an email field (not a problem) and then create further sub lists that contain any duplicate emails. At the end, each sub list should only have 1 copy of any given email. I'm not looking to delete duplicates, just separate them into unique sub-lists as the remainding information in the record is different and needs to be treated separately. Each list has a code taken from the first column in the list, and I would like to name them CODE-DATE-email-sublist#.csv. I can do this part already without the sublist# part - I'm guessing that I need to set up some sort of counter for that. The naming convention will always be the same, however I don't know ahead of time if there will be any duplicate emails etc. necessitating futher sub lists. Some original lists may contain several duplicates of 1 email, and some may contain none. There are about 30 columns of info in the lists, and I need to do a EntireRow copy, butI will give an example with just 3 columns to illustrate. Code Email info A a...@a.com 1 A b...@b.com 2 B c...@c.com 3 C d...@d.com 4 C d...@d.com 5 C d...@d.com 6 C e...@e.com 7 This original list would end up creating 5 distinct files for me at the end. A-Oct-27-2009-email-1.csv B-Oct-27-2009-email-1.csv C-Oct-27-2009-email-1.csv C-Oct-27-2009-email-2.csv C-Oct-27-2009-email-3.csv In the case of Code C, the first file saved would contain 2 rows, and the subsequent files would contain rows each. i.e. each file saved would contain fewer records until all of the duplicates have been dealt with. I hope that this makes sense, and please ask any questions you may have. Many many thanks for your help. Chris --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
