Auto Filter Entries

[Mark McDonough]

Is there any way to extract the detail listed in drop down auto filters?

I work with files where there are numerous entries of the same customer name
for each customerustomer in the one list along with other data in the file.
When you select the drop down box in the auto filter you get a list of
customers. It's that list that I want to put on another worksheet so that I
have only one listing per customer rather than 20 or 30 of them.

Or, maybe there is a better way you fine people might suggest.

Cheers
Mark

 

[Sandy Mann]

Advanced filter will do that for you. Start the Advanced filter in the
sheet that you want the list to be entered in. Select: Copy to another
Location & Unique records only and you don't need to enter anything in the
Criteria Range box.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk