Keeping track of data over time even if the data is no longer visible.

[hoboking87]

Hello, everyone.

I've been trying to find an answer to this problem for a while, and it's pretty difficult to explain. Here goes:

I work in a medical facility, and I need to track data I've entered representing patient visits indefinitely over time. I've attached a weekly grid to this thread that I use to record which patients have had visits during the course of the week. It sums their total visits on the right. I need to continually track these because every patient gets an insurance-mandated progress update after 10 visits. Unfortunately, they don't always show up, and the most I can possibly keep track of is two weeks, max, and most patients only get two visits per week. Is there a way to dump these sums into another column indefinitely?

Thanks for any help.

-Hoboking87

Weekly Schedule.xlsx

[FDibbins]

Hi and welcome to the forum

Your data is hardly descriptive of what you want us to work out? Having 23 rows of identical data, doesnt give us much to work on, sorry

I understand the sensitive nature of the data you work with, but at least try to give a some=what representative sample of what you are working with