macro for duplicate checking in one column
 

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,

macro for duplicate checking in one column
 

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,