Everytime I try it doesn't allow me, and says to use a single selection. I don't understand why it can't just copy the data into the approriate matching cells. I am using Auto-filtered cells. So if I have 1000 lines to my file and I filtered 5 of those lines, and want to copy and paste 5 lines from column D to the same 5 lines in column A, it doesn't let me. My 5 lines may be line 12, 234, 1400, 1406, and 2345. Etc... Anyone know how to make this happen?