Get data from column and put into Combo Box

[annettes]

Hi Gurus,

there're many columns in worksheet A. I want to get data under a column ("Type") from worksheet A, if data is duplicate, skip. else, add into combo box in worksheet B (same workbook).

1. How to get the correct column from worksheet A
2. How to add data into combo box without duplication.

My data in column "Type" for worksheet A, for e.g

Type
----
box
box
box
drum
drum
drum
drum
pallet
pallet
bag

Result I need to get for combo box in worksheet B:

Type
----
box
drum
pallet
bag


Anyone has any idea?

Thanks for your help.

Best Regards,
sue

 

[Chance1234]

you could use an advanced filter and named ranges

Chance,

F, G + yeah reached 50