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.

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.

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.