I am sorry but I don't quite get what you mean by "copies the columns next to it"
Do you mean cells to right or left?
Same goes for "pastes them back in the original sheet". Were they cut before?
Recently there was a thread where the OP wanted to be able to select certain columns in 2 sheets to compare and copy the found duplicates to a third sheet.
Is that similar to what you have in mind or am I way off track here.
If it is, have a play with the attached and, if possible, let us know if it is close at all.
Reply With Quote
