Hi,

Please find attached an example of what i'm trying to achieve...

Basically I load data into the data tab, which will have more rows of data - what i'd like to do is filter by unique values then copy and paste those values into the other worksheet "Unique_Values"

Hopefully the attached explains it better.

Thanks in advance

ColinTest.xlsx