I'm putting together a 12 month expense budget worksheet for each of our cost
centers. In it, I would like to be able to have the cost center managers
input for each applicable GL the annual amount, frequency of the expense
(monthly, quarterly, one time, etc) and have the worksheet automatically
calculate the 12 month budget for all the different frequency types. For
excample, if the cost center manager put in an annual amount of $800, a
frequency of monthly, and a beginning month of April, I'd like the worksheet
to automatically put in $100 in months April - December for that line item.
Same for the other frequencies. How can I do this? Thanks!