View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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,