Hello all!
I am attaching a worksheet so you can see what i'm dealing with. I have a list of 1000 names of people. Those people have agents that represent them. A lot of the names are represented by the same agent. I need to send only one email to the agent with the names of every client they represent. I'm looking for a macro to that looks in Column Z and if the emails match to combine and separate with a column all the Values in Column D.
Take a look at the spreadsheet. Thank you!
TestSheet.xlsx
Bookmarks