Select the list Data Filter Advanced Filter Copy to another range
Copy to 'click destionation cell" OK

HTH
Regards,
Howard

"David T" wrote in message
...
I have a list of items in column A and I need to create a drop down list in
column B that excludes any duplicate data. Does anyone have a macro that
can do this?

Column A Column B
apple {drop down list inserted here}
pears
orange
apple
orange