Hello,

On one worksheet I have a number of rows of data of schools, town names, colleges, companies etc in column D.

I need to create a macro which finds the duplicates in the column and copies them into row A on "Sheet2".

An added extra would be for this data in "Sheet2" to be sorted by the number of duplicates. I.e. if ASDA features 15 times this would show up at the top.

Can this be done?

Many thanks,

Chris