How do I set some wksht formulas to calc. manually and others to calc. automatically?

[hoboking87]

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

[FDibbins]

Hi and welcome to the forum

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

you thought wrong lol. Most members are unwilling to retype your data, and would also like to see what VBA you already have in your workbook