Copy multiple entries and paste without duplicates

[ExcelMonkey]

I have a column which is a field within an excel spreadsheet. Its
country field denoting country names. I have multiple entries for al
the various countries. I want to highlight the the entire column, cop
it, but when I paste it I only want to paste each entry once
Effectively its like exporting all the possible field entries withou
repeating one of them.

Example I want to highlight the range A1:A6

Brazil
Canada
USA
Brazil
Canada
Chile

The paste to a new sheet. When pasted it will look like this:
Brazil
Canada
USA
Chile

I want to be able to highlight the column and have the macro work of
the active range. Can anyone help with this?

Thank-yo

 

[Frank Kabel]

Hi
try using 'Data - Filter - Advanced Filter' and check 'Unique values'

 

[ExcelMonkey]

Thanks Fran