Team,

I need to have excel insert values in monthly sheet based upon start date month, period (say months) and monthly amount. - the values and periods will vary so I cannot just have fixed formula calculation

on one row lets say expected revenue amount of $1200 over the 18 months(note the amount and the period could vary based on calculations for each row of data) starting Jan 2012

I would like excel 2010 to make the calulation of $1200/ 12 and then place $100 in a cell under each month Jan to Dec (months will be shown above) until the period is reached.



Thanks

Shesez