Hello, everyone. I'm having a problem with a scheduling tool I'm updating for a health care facility where I work. I need to track patients' visits weekly as long as they are on our caseload. I've figured out how to do that using a custom function in VBA. Here's the code:

Function Cumulate(weekly, cumulative)
Cumulate = weekly + cumulative
End Function

And here's the grid (it's a screenshot; i figured nobody would open a file with macros in it...)

Scheduling Grid Screenshot.docx

In the second-to-last column on the right side of the grid, I have COUNTIF functions that total the number of weekly visits each patient receives. They look like this:

=COUNTIF(cell1:cell2, ">0")

I need these to remain automatic for the supervisor to adjust throughout the week.

In the last column on the right side of the grid, I have the CUMULATE functions i created in VBA that track the total cumulative visits the patients' have received since they got onto the caseload. They look like this:

=CUMULATE(cell1,cell2)

I need these to be manual so the supervisor can run the function at the end of each week. How do I do this?

Thanks for any help. I'm new here, so let me know if you need any additional information.

-Ryan