I need to keep track of attendance and enrollment. I have one master sheet of every person. As a person enrolls/attends, I'd like the master to auto update. Enrolls/attends are provided as separate system reports. The two columns are G and H on the master sheet in the screenshot is what will change. This is the shareable sheet (download as .xlsx) as I cannot attach files.
I found this resource which is exactly what I want to do. When I updated the code, I received an error. Is there another way?