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.
Thank you so much for all the help! This will work for me, and I will make some other adjustments. You're the best!
You're very welcome. It was a very interesting project.