I have a filter system to use with a mailmerge 'database' which works perfectly as long as we want to filter by one of the set combinations given on the userform. By the way, the system removes all the items found by this filtering to a new spreadsheet, which is why we don't just use autofilter!
However, I would like to add a custom filter to this, with two dropdown menus - the first will populate with the column headings, then on the user selecting the heading they want, the second would auto-populate with the possible options in that column.
I presume I also want to add an option to say "there are more than # options in this column, please choose another column to filter on", so they don't try to filter by address or something ridiculous (these 'databases' sometimes contain 10s of 1000s of entries!), where # is the maximum number of items you can populate a dropdown box with - I seem to remember seeing somewhere that this was 25, but I'm not sure.
I'm pretty certain I can do the code behind it that actually does the work ( <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> !) but would someone point in the right direction as to how to get started on setting up the two dropdowns, please?
I would be most grateful!