I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!

http://office.microsoft.com/en-us/ex...CL100570551033

Try the above page. I think it will help you!

"rebeccca" wrote:

I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!

Most likely can be done but from your description it is difficult to give a "how
to" answer.

How will Excel know if "the subject applies"?

What criteria determine this and what type of option is required?

A better description of your data layout would help.


Gord Dibben MS Excel MVP


On Wed, 11 Apr 2007 07:24:04 -0700, rebeccca
wrote:

I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!

I find that using another column and putting an X (or any non-blank character)
in that cell is easiest.

Then I can apply data|filter|autofilter and see all the non-blanks or blanks.

rebeccca wrote:

I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!

--

Dave Peterson