Check Boxes and Sorting/Filtering

Good afternoon,
I have a report i have created (document actually) where I have inserted Check boxes in column Q under the header Updated. The purpose would be that my Team lead can go into this document - go to column Q and filter/sort and pull only the one that have a checked box (have been updated) - now how in the world do i go about doing this? I know there is a way, but i am racking my brain.

I have 2010 excel.

Any help would be greatly appreciated!! thank you in advance


Holly Noel

You can link the checkbox to the cell that it sits on. This has to be done manually for each checkbox (it is possible to do it with VBA code for ActiveX checkboxes; it might also be possible for Forms checkboxes but I don't know how). For a Forms checkbox, right-click on the checkbox, go to Format Control, Control tab, and fill in "Cell link". For an ActiveX checkbox, right-click, select Properties, and fill in LinkedCell.

Now when the box is checked, the linked cell will have the value TRUE and if unchecked it will show FALSE. You can use AutoFilter to do filtering and sorting.

However, I will add that I am a believer in simple, obvious solutions. Why don't you just have the user put an X in Column Q, instead of using checkboxes? That way you don't have to create new checkboxes every time you add data, and there is no manual setup required.