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
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