I have a list of 100 values in excel. I want to use check boxes to select out the two or three of these values that apply in a specific instance.
Simple enough. I create a form check box for each entity, click the ones I need and add the values to create a total for this instance.
My problem is when creating this sheet, it is unwieldy. The check box does not "drag" with the rest of my formulas and I end up with check boxes not associated with the cells in question, requiring an endless process of editing each check box. This leads me to believe that I am misusing check boxes...
Any ideas? Thanks