Macro stopped working. Copy cells from one sheet over to another based on adjacent cells.

So what this macro did was look at two columns on one sheet. Column A contained user names, column B contained their emails. Then it would replace everyone's name on a different sheet with their emails. However, now it only does it once, and if the name shows up more than once, the extras don't get replaced by the email. My understanding of VBA is almost non-existant. Please help?

Please Login or Register  to view this content.