Hello. I am attempting to create a sheet where I have a list of students in a dropdown menu (the names are being auto-populated from another sheet); the rest of the sheet has checkboxes with a formula that adds up how many checkboxes are checked.
I am able to choose a student name, check off boxes, and have that total automatically populate on a different workbook.
But now I want to choose a new name from the dropdown, and for the checkboxes to go back to blank, and for the new total to populate in the corresponding student's cell.
I'm not even sure if that can be done. Any ideas would be a great help.
You would need to write a routine that would capture the total against the student and then clear all check boxes.
You could start by using the Macro Recorder to capture the code that is created when manually performing the actions you want to perform and then amending the code to make it repeatable. This is not a simple task.