Automatically Updating Table (Formulas Present) - Unsure what to use.
This is clearly not a finished data set, table, formulas, etc. so PLEASE keep that in mind. I'm only attaching the photo to try and explain what I'm trying to do better.
I am trying to create a worksheet where each month I can input data and then use formulas to get back the KPIs I'm looking for. For example, occupancy each month is # of occupied beds/# of total beds. Some of the other formulas will be more complex than that.
How can I have the formulas update automatically with each month's data? So for january the formulas are pulling from B19:B41, and then for february C19:C41, and so on.
That's the minimum of what I'd like to do: essentially update the above table with the information monthly. If there's also a way to be able to compare each month against each month, that'd be helpful as well.
Thank you in advance for help. I'm sorry if this is any easy solution - I've been trying to google and find the answer and can't.
[link] [comments]
Want to read more?
Check out the full article on the original site