I have setup the following 3 year project with total $300 budget:
b1=$300, c1=3years, d1=$100, e1=$100, f1=$100, g1 is empty
if I change the value in d1 to $0 (meaning, I don't intent to spend any
money this year), I need excel to find the next empty cell which is g1 and
move data from f1 to g1, from e1 to f1 and from former d1 to e1.
This is an oversimplified version of what I need to accomplish. I have 50
projects with different year lenghts and money not always distributed as 1/3,
1/3 & 1/3. I could have 25%, 30%, 30% & 15% for a 4-year project and other
combinations.
Does anyone know how to automate this procedure so I could setup 1 formula
for each project and forecast my spendings by changing amount in the current
year (d1)?
Any help would be greatly appreciated.