Hi, Thanks for the reply, the code needs to paste the values only into the range of cells on the same row were the new customer name is being entered. I wrongly assumed that active.cell would do this but I think that's part of my problem. I can manually find and copy the selections at the same time then paste ok, but I'd like to do this via a macro after entering the new name, either by using a macro or with the worksheet.change event