Copying unique data that ends with a specific character

Closed
Don - Sep 3, 2016 at 10:40 AM
Hello,

I want to create a workbook that has a main input worksheet, then automatically copy new data that ends with a specific character to a specific sheet.

Like, if a data ends with, for example, number 1, copy it to another sheet, for example, named "Ends with 1". If the data already exists on the sheet, don't copy it.

Need help guys. Thanks.