Forum Discussion
Solved
Restricting cells from equaling above a value
Hi If I have B4:B6 B9:B11 B14:B16 B19:B21 I want to be able to enter values into B4 going down and the remaining values will populate in the cells. I want the cells to populate based on t...
Here's a further cleaning up of the last version. Made to be a bit more flexible. You can just enter any annual goal in cell A1 and have it apportioned out equally among the months.
Then enter the actual for each month as that actual is known; the subsequent months are adjusted so that the annual goal is shown as still achievable.
I've added a bit more documentation, including brief explanations of the two most significant formulas.
Hey man this is amazing! This is just what I am looking for. Is there also a way to make it divide out evenly among the months? So if you were +1000 for January that surplus would not be necessary for the remaining months instead of just 1? if not, it is okay. I appreciate it sm!
It's possible I'm sure, but I'm not succeeding in the short term. I've gotten it to adjust each month, but it adjusts retroactively too, which you don't want. The spread of remaining has to go only to future months. It's intriguing, so I'll keep working at it, but it may take a while (since I do also have a life outside of this forum)>