I have a worksheet with 24 columns (A to X) in sheet 1. I copy and paste a large table from the another excel sheet into these columns and some of them are duplicates.

I would like to be able to run a macro to find the duplicate cells (in Column A,C and D) and move the duplicate cells in the sheet 2.

Can anyone tell me how to do this?

Thanks.