Hi,
I have 3 columns A,B & C. Column A contains my budget by month lets say $9,000 in January followed by a total budget at the bottom, column B contains my actual spend by month $9,111.09 in January followed by a total spend at the bottom, Column C contains my remaining spend -$111.09 for January derived from the formula =a1-b1 followed by a remaining spend total at the bottom. What I would like to happen is that each month the new budget increases or decreases based off the total budget and months remaining.
Bookmarks