Which macro are you referring to, the one I suggested or the one suggested by dangelor? Can you attach a copy of your file with the desired result in the "Shared Contact Pivot" sheet?