HI,
I have received very two lists of contact information that have been combined into one sheet as seen below. I have broken this down into a smaller sample size because each list contaions over 5,000 rows and 20 columns wide. My question is....
Is there a way to sort the list below by Last>First>State so that if there is a duplicate within list 1 and list 2 they would be within the same row side by side. If the contact is unique to only one of the list, the other list would insert a line in the opposite list. Im having a hard time wrapping my head around this concept and have been manually inserting lines and formatting these two lists to that they match up correctly. I have added the desired format below in picture two to give an example.
[/URL][/IMG]
Notice how in this Picture below....
If the contacts match up they will be side by side.
If the contacts have same First and Last, they are sorted by state.
If the contacts are unique, the corresponding row in the other list is populated with an inserted blank row.
[/URL][/IMG]
So, is there a way to do this through VBA, V-Lookup? Array? Macro? Any help on this would be high appreciated. I've been working on this project for over a month.
I have received very two lists of contact information that have been combined into one sheet as seen below. I have broken this down into a smaller sample size because each list contaions over 5,000 rows and 20 columns wide. My question is....
Is there a way to sort the list below by Last>First>State so that if there is a duplicate within list 1 and list 2 they would be within the same row side by side. If the contact is unique to only one of the list, the other list would insert a line in the opposite list. Im having a hard time wrapping my head around this concept and have been manually inserting lines and formatting these two lists to that they match up correctly. I have added the desired format below in picture two to give an example.
Notice how in this Picture below....
If the contacts match up they will be side by side.
If the contacts have same First and Last, they are sorted by state.
If the contacts are unique, the corresponding row in the other list is populated with an inserted blank row.
So, is there a way to do this through VBA, V-Lookup? Array? Macro? Any help on this would be high appreciated. I've been working on this project for over a month.
