krackers
03-01-2020, 06:48 AM
I have a large sheet of names and addresses. Names are in the form of first names and second names and then address details in same row.
Some entries are for married couples but each individual has their own line of data with address details repeating along the line of data for a married couple.
I have a need to produce a mailing list showing only the persons initial of their first name and combining into one line where married couples exist.
There are entries of the same name but not a married couple. A married couple can be assumed if both the surname and address details match.
I attach a sample sheet showing what I am trying to achieve. Sheet 1 shows how the data is stored, sheet 2 shows what I am trying to achieve.
The whole process of producing the list is via a cmdbutton and as data changes each month and the mailing list is needed every other month, I want to achieve this using vba code attached to the cmdbutton.
I have had several attempts at getting started but not getting anywhere fast - can someone please point me in the right direction. I'd be most grateful for your help.
Many thanks,
David
Some entries are for married couples but each individual has their own line of data with address details repeating along the line of data for a married couple.
I have a need to produce a mailing list showing only the persons initial of their first name and combining into one line where married couples exist.
There are entries of the same name but not a married couple. A married couple can be assumed if both the surname and address details match.
I attach a sample sheet showing what I am trying to achieve. Sheet 1 shows how the data is stored, sheet 2 shows what I am trying to achieve.
The whole process of producing the list is via a cmdbutton and as data changes each month and the mailing list is needed every other month, I want to achieve this using vba code attached to the cmdbutton.
I have had several attempts at getting started but not getting anywhere fast - can someone please point me in the right direction. I'd be most grateful for your help.
Many thanks,
David