I totaly blew this one... I made this much more complicated than i needed to. I sorted sheet1 by the buyer code. then copied the sorted the range...emailed the sheet...went back to the original sheet...repeated the process.