Jul 15 2019 02:40 PM
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.
Jul 15 2019 05:24 PM