Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkbox in dropdown question
I am trying to make a dropdown that will work similar to auto filter except
using checkboxes so I can pick several dates and only see the ones that I want to. I know this should be easy but I just can not find out how? Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkbox in dropdown question
Hi,
The easiest way is to upgrade to 2007, the AutoFilter has this checkbox feature built in. In 2003 I would suggest looking at the Advanced Filter command, in that case you set up a criteria range the would look something like: Dept Acct Admin Sales where Dept is one of the titles in your data and Acct, Admin, and Sales are the three you want to see. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Greg" wrote: I am trying to make a dropdown that will work similar to auto filter except using checkboxes so I can pick several dates and only see the ones that I want to. I know this should be easy but I just can not find out how? Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkbox in dropdown question
This would be hard to keep up with since I add data every day and the dates
change. There are usually 5 - 10 enteries per day and a months worth of data on each sheet. There are about 50 users that use their own copy of this and most will not be able to do a lot in excel. :( "Shane Devenshire" wrote: Hi, The easiest way is to upgrade to 2007, the AutoFilter has this checkbox feature built in. In 2003 I would suggest looking at the Advanced Filter command, in that case you set up a criteria range the would look something like: Dept Acct Admin Sales where Dept is one of the titles in your data and Acct, Admin, and Sales are the three you want to see. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Greg" wrote: I am trying to make a dropdown that will work similar to auto filter except using checkboxes so I can pick several dates and only see the ones that I want to. I know this should be easy but I just can not find out how? Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help - Checkbox Data Validation question!!! | Excel Discussion (Misc queries) | |||
Checkbox Question | Excel Discussion (Misc queries) | |||
Code question for clearing a command checkbox. | Excel Discussion (Misc queries) | |||
Checkbox Question | Excel Discussion (Misc queries) | |||
Checkbox question | Excel Discussion (Misc queries) |