Copy Autofilter dropdown results

mrholiday

Board Regular
Joined
Jan 27, 2006
Messages
57
Hallo Dear Fellow Programmers,

I have a question about Autofilter dropdown results! :cry:

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 ) :eek:


Thanks in advance for any feedback..... :p


MrHoliday :rolleyes:
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Joined
Jul 30, 2006
Messages
3,656
Try copying, and Edit PastSpecial, Values to another free area in your workbook.


Have a great day,
STan
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top