Hello,
I am trying to set up a guest list. My goal is to have a column of about 150 check boxes for 3 different columns. Such as a check if someone was invited another if they rsvp'd and another if they attended.
The problem is that each check box is linked to the original cell and if I go through and change one column to each cell then the next column will be linked to the original check box in the other column.
My question is Is there anyway to make multiple check boxes for multiple columns without having to assign each one to a cell?
I found a macro that lets me assign individual check boxes in one column but I it doesn't add any kind of value to them and I need at least the true or false to pop up for sorting.
Any help is appreciated
I am trying to set up a guest list. My goal is to have a column of about 150 check boxes for 3 different columns. Such as a check if someone was invited another if they rsvp'd and another if they attended.
The problem is that each check box is linked to the original cell and if I go through and change one column to each cell then the next column will be linked to the original check box in the other column.
My question is Is there anyway to make multiple check boxes for multiple columns without having to assign each one to a cell?
I found a macro that lets me assign individual check boxes in one column but I it doesn't add any kind of value to them and I need at least the true or false to pop up for sorting.
Any help is appreciated