transfer duplicate data and invalid data on other sheets..

i try making macros for excell to extract duplicate data and certain invalid data like segregate the numbers, from data having cahracters but i don’t have the enough knowledge onhow to do it…