checkbox in dropdown question

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

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.
 
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.
 
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
 
Back
Top