C
Carl W.
I am not sure if the use of the check box is correct. I am new to forms in
Excel 2007and don't even know how to add multiple items to be checked or if
that is possible.
My scenario is this:
I want to be able to have in cell C1 the ability to select from 5 options
(able to select 1 or more of those). I would like the same options to occur
down the column - C2, C3, etc. After the user selects those options for each
row, I need to be able to filter based on those selections. Ex: show all rows
where Option 2 & 3 were selected.
I need to be able to show all or just the filtered selection in print
version, so I don't want to have to create a new row for each option and
create a much larger print version of the info.
Any help is appreciated. Thanks.
Excel 2007and don't even know how to add multiple items to be checked or if
that is possible.
My scenario is this:
I want to be able to have in cell C1 the ability to select from 5 options
(able to select 1 or more of those). I would like the same options to occur
down the column - C2, C3, etc. After the user selects those options for each
row, I need to be able to filter based on those selections. Ex: show all rows
where Option 2 & 3 were selected.
I need to be able to show all or just the filtered selection in print
version, so I don't want to have to create a new row for each option and
create a much larger print version of the info.
Any help is appreciated. Thanks.