A continually updating project

[KingKimo]

Hello all

I am working with my hospital to compile data of covid vaccines done daily involving a bunch of different variables that change daily and are updated daily. My aim is to create a second sheet that's able to continually compile that data....without creating cells for each day or a new sheet for each day

My panacea idea would simply to create a command that says "If today's date is not the last recorded date, take value from Sheet2:D4 and add it to what the last sum calculated yesterday" That way we update the same sheet, with new info every day, without creating an entirely new sheet. The challenge is the sheet is going to be used to calculate ALL THE SHOTS given until all vaccines are complete, sometime later in 2021.

Any info would be helpful

Sorry, I cannot provide my working sheet due to HIPAA.

[Pepe Le Mokko]

Please post a sample mocked up sheet with some data and expected results. Thanks

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. I would do it for you if I understood your requirements ...)

[Glenn Kennedy]

We don't need to see your real sheet. Mock up 10-20 rows with imaginary names and numbers. It won't take you longer than a minute or two.