Copy Autofilter dropdown results

[mrholiday]

Hallo Dear Fellow Programmers,

I have a question about Autofilter dropdown results!

In the Autofilter dropdown list are only the
- remaining choices visible
- sorted in ascending order
- no duplicates

I need to get this information copied out to be used as Fill List in a combobox.

Example:

I have in the table with 6 rows still visible. In column 5 following names:

- Paris
- Berlin
- Rom
- Amsterdam
- Berlin
- Paris

If I use the Autofilter drop down list only following is shown:

- Amsterdam
- Berlin
- Paris
- Rom

only the
- remaining choices visible
- sorted in ascending order
- no duplicates


I need to know how to copy only this "cleaned" in cell A1 (so that I can use this information as Fill List in Combobox1 )


Thanks in advance for any feedback.....


MrHoliday

 

[stanleydgromjr]

Try copying, and Edit PastSpecial, Values to another free area in your workbook.


Have a great day,
STan