If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Budgeting - adding an adjustment cell to a budget for all 12 months

Thread starter frankday
Start date Jul 17, 2023

frankday

Board Regular

Jul 17, 2023

I have a line item on my budget that has a total for each month. I want to be able to make an adjustment to each month and have the adjusted number that I entered be the new number on the budget without changing the year total. For example, if my year total is $7,500 and January auto calculates $225.88 and February auto calculates $222.59 and so on. If I change January to $0 I want February to change to 229.50 and so on so the year total remains $7500. I'm able to make this work but with a lot of calculations and formulas. I am hopping that there is an easier way to do this with the new formulas out there.

Thanks for your help.