Creating a Formula based on time frame in a drop down box

[Caileanbw]

Hi All,

If anyone can help, I'd greatly appreciate it. I’m trying to create a formula that says – If you select “Monthly” from the drop down list in column L, then the total cost in column K gets listed in each month (starting in column O) . If you select “Quarterly” then you have to select “Beg, Mid, End” in column M, then it would list the amount in column K to those months that are in the Beginning, Middle, or End of the Qtr. If you select “Annually” then you have to select the month it would be in from the drop down list in column M and then the total cost in column K would be picked up in that one month.. See attachment.

Formula.jpg

[zbor]

You need VBA for this.
If you are OK with that please upload example workbook (rather than picture). Make sure to remove private informations.