Hey everyone,

Excel 2007. This one is challenging - don't even know if it can be done.
My current layout:

A B C D E F G H
Project budget months start jan feb mar apr
a 50000 5 mar
b 20000 6 may
c 25000 4 sept
Taking "Project A", I would like the divide the given budget across five
months starting in March (so on that row for example, you would see "$10,000"
for each month from Mar through July). Same for Project B - it starts in May
and lasts 6 months. My budget is 20,000, meaning each month has a budget of
about $3300. Sounds easy - here's the catch.

I want to be able to change any one of the parameters for Columns B, C, or D
AND have the corresponding monthly breakdownds update automatically. For
example, if I changed the Start Month for Project A to January (instead of
March), I want those individual "$10,000" numbers to automatically move so
they begin in Jan and now end in May. Likewise, if I changed the length of
any project (i.e. make Project B "8" months instead of 6, I now want to see
$2500 for those eight months (May - Dec) instead of $3300 for the original
six.

Hope that makes sense. I don't have confidence this can be done, but I'm
hoping someone out there can help. THANK YOU!

Joe