Update Master Sheet as data changes from another sheet

Occasional Visitor

Newbie here.

 

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?

 

Thank you!

Screen Shot 2022-01-23.PNG

0 Replies