Pasteing a list without duplicates
 

I have a list that I wish to copy but upon pasteing I would like any repeated
items in the list not to be copied.

Trying to work it out using other VB I've copied for drop down menus but
can't seem to get it to work.

TIA
Matthew

Pasteing a list without duplicates
 

That is exactly what Advanced Filter can do under the Data menu. If you want
VB then record a macro while using the filter.

Mike F
"Matthew Balch" wrote in message
...
I have a list that I wish to copy but upon pasteing I would like any
repeated
items in the list not to be copied.

Trying to work it out using other VB I've copied for drop down menus but
can't seem to get it to work.

TIA
Matthew