I need a macro to search column A on sheet one for duplicates and each row that is a duplicate copy entire row to a sheet named duplicates. Can anyone help?



Thanks,
Allen