Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to auto-filter combo boxes
How can you manipulate the dropdowns that Auto-filter creates? I would like to add some new entries and delete some of the ones it automatically creates. Here is what I would like to do I have a spreadsheet that has dates as one of the fields. I would like allow people to select January, February, etc. from the date combo box (while Auto filter just gives me a list of all the dates). I know how to do this for one month at a time using the custom option, but I would like all months listed. This spreadsheet also has a list of ID numbers that are often duplicated. I would like to add something to the combo box that filter so it only shows unique records. I was able to create an advanced filter that did this but would like to make it easy for people to use. Thanks -- bsherwood ------------------------------------------------------------------------ bsherwood's Profile: http://www.excelforum.com/member.php...o&userid=32351 View this thread: http://www.excelforum.com/showthread...hreadid=521123 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to auto-filter combo boxes
No, you can't manipulate the Auto-Filter dropdowns.
In order to achieve what you describe, you will need an Advanced Filter HTH -- AP "bsherwood" a écrit dans le message de ... How can you manipulate the dropdowns that Auto-filter creates? I would like to add some new entries and delete some of the ones it automatically creates. Here is what I would like to do I have a spreadsheet that has dates as one of the fields. I would like allow people to select January, February, etc. from the date combo box (while Auto filter just gives me a list of all the dates). I know how to do this for one month at a time using the custom option, but I would like all months listed. This spreadsheet also has a list of ID numbers that are often duplicated. I would like to add something to the combo box that filter so it only shows unique records. I was able to create an advanced filter that did this but would like to make it easy for people to use. Thanks -- bsherwood ------------------------------------------------------------------------ bsherwood's Profile: http://www.excelforum.com/member.php...o&userid=32351 View this thread: http://www.excelforum.com/showthread...hreadid=521123 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Problem Adding new Combo Boxes | Excel Discussion (Misc queries) | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Adding the same content to multiple combo boxes | Excel Programming | |||
Question on Input Boxes and Auto-Filter | Excel Programming |