Is there a specific code that i can use to remove duplicates from a list. I
want to be able to do this using code rather than manually so that when I
copy in a large list of data I can make a copy of one of the columns and
remove the duplicates from this and paste it on another worksheet of the
workbook.

Thank you very much for your help,

Michelle

Hi,

Use an advanced filter but to copy to another sheet you must start from that
sheet or you will get an error.

So on the destination sheet

data|Filter - Advanced filter - select copy to another location
Click the box to the right of 'List Range' and navigate to your data and
select it all
Check unique records only
Click the box to the right of 'Copy To' and select a single cell to copy the
unique list to

OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"michelle439731" wrote:

Is there a specific code that i can use to remove duplicates from a list. I
want to be able to do this using code rather than manually so that when I
copy in a large list of data I can make a copy of one of the columns and
remove the duplicates from this and paste it on another worksheet of the
workbook.

Thank you very much for your help,

Michelle