Hey!
I've been working on a project to help shorten the time it takes to filter and sort out some contacts from a spreadsheet to upload as a CSV. Only thing is I have run into a roadblock with a specific part of the sorting process which is compressing contact information of contacts with different names but using the same email.
I have attached an example of what I mean, but in words, the contact list is to send to a list of contacts that have family members in a retirement village. there could be multiple contacts for one person or multiple people for one contact.
I'm wanting to detect the duplicates by email and then it will concatenate any first or preferred names and then can just delete the rest. The first row of double data would be the one that would stay.
I already have a macro workbook with a heap of VBA in it doing other things so having this solution in VBA will help a heap. Don't worry about Dim names and stuff, I can go through and adjust to suit what I have on the other workbook (just not sharing it as its confidential information)
This needs to be Mac friendly.
Let me know if I need to explain more.
Bookmarks