List but with a twist...

[kidmullet11]

Hi guys

I have a raw data sheet with hundreds of rows all with standard column headers (date, product etc).
I want to be able to create a drop down list to chose one of the dates, products etc. but each of these metrics is repeated many times over in the data sheet.

If I create a drop down list referencing the columns as they are, it lists each month over and over again almost like a unique entry.
I know the easier way to create a drop down list is just to create a table with 12 unique references to Jan>Dec etc but is there a way I create a unique drop down list from my original raw data sheet as it stands?

Thanks!

 

[rpaulson]

here's what I do.

create a new sheet to store the unique lists on:
in my code this new sheet is named "lists"

Sub Generate_lists()

With Worksheets("lists")
Range("A:A").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("A1"), Unique:=True
Range("B:B").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("B1"), Unique:=True
Range("C:C").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("C1"), Unique:=True
...
End With
End Sub

hth,
Ross