Maybe EasyFilter is option for you
http://www.rondebruin.nl/easyfilter.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Dev" wrote in message ...
Hi there,
I wanted to create a macro in excel for checking the duplicate for the
values placed in each of the cell in the entire column or untill the extent
data is available in the column.
Besides, after checking for duplicates that duplicate list should presented
in a new worksheet.
rgds,
Dev,