Mark your range of data
DataFilterAdvanced Filter select Unique values and Copy to Another
location and make Copy to Sheet2!A1
Switch on the macro recorder as you carry out this task then invoke the
macro each time you wish to use.
--
Regards

Roger Govier


"JGB" wrote in message
...
Has anyone got a macro that will find duplicate values/names on a sheet
and
copy just one of those values onto a seperate sheet within the same
workbook.