Use the Data Filter AdvancedFilter command. Here, you can set the correct
options to Copy to another location, set the Output range (the single column
for the item you want), and check the box "Unique Records Only".
Stan
> Stan Scott
> KPMG Client Service Technology
> [log in to unmask]
-----Original Message-----
From: Mick Fitzpatrick [mailto:[log in to unmask]]
When one adds Data Filters to an Excel worksheet you get a tidy little drop
down menu showing all the entries in that particular column in alpha order.
Is it possible to 'grab' that information from the drop down list.
-----
**Need help with PCSOFT mailing list? Send an Email to:**
Bob Wright<[log in to unmask]> or Drew Dunn<[log in to unmask]>
|