how do I create a checklist

[nicole]

Please help.

I have all of my data inserted. I have created one column of check
boxes and one column of data. I want to be able to check the boxes
that apply for any given situation, and print only those rows that
have check boxes. I do not want the check boxes to show up when I
print.

i.e.

X Data 1
Data 2
X Data 3


Since row 1 and 3 are checked, column one and three would print out.
I do not know how to link the two columns, and format it so that 1 and
3 would only print.

Thanks.

 

[Fable]

Hi Nicole,


Why not use the "auto filter", this will shorten the list to those wh
you filter out.


Hope this helps

 

[David McRitchie]

and if the checkmark is in Column A then you can set the
print area to columns B through whatever is reasonable.