thanks for the advice. I could do this but I'd still have to run the macro every time. I want it so that as soon as I paste in the data, the data is populated in a different column without duplicates. is this possible?