Sorting Data with Check Boxes in excel 07

[bdavenport]

I have a spread sheet with names, adresses etc. I want to create a
check box to simply let me know if they have or have not turned in a
certain form. I was able to insert that no problem, but when I go to
sort the data by a different heading the checked box does not move, it
stays in the same cell which means it is no longer useful and accurate.
Any way to lock the box to a cell/name?

 

[Steve Rindsberg]

I have a spread sheet with names, adresses etc. I want to create a
check box to simply let me know if they have or have not turned in a
certain form. I was able to insert that no problem, but when I go to
sort the data by a different heading the checked box does not move, it
stays in the same cell which means it is no longer useful and accurate.
Any way to lock the box to a cell/name?

Why not enter anything at all into the cell to indicate a response; blank
cell = no response.

 

[bdavenport]

Sure that's an option, but I would rather be able to lock the boxes t
the cells when things are moved around