VBA routine to find and delete entire row based duplicate values within column selected by user
Read this post on yogeshguptaonline.com