I've got an interesting one that I hope someone can help me with.
I have a spreadsheet with two drop-down lists and two cells to fill in and this populates data in a table so that a journal entry can be entered into the accounting software.
The drop-down lists consist of the following:
1. Type = Annual or Prorated
2. Month = months of the year showing first three letters of the month
I have figured out how to calculate the prorated amount per month but I am struggling on how to calculate the annual amount. The annual amount depends on what month is selected in the month drop-down list, and of course annual being selected in the Type drop-down list. For each account that I have listed in column B, if annual is selected, and say for example JUL (July) is selected in the month, I want everything from April to July included in July's data and all other month's going forward to have their prorated amount.
Here's an example for you:
If the data was stating the following for each month: April = 1, May = 2, June = 3, etc. until March = 12. If I select July in the month drop-down list, I would want July's data total to be 10 (1+2+3+4) and August to March to show their correct amounts (i.e., 5 to 12).
I would be very grateful if someone could help me with this. The solution can be macro or formula generated, I have no preference.
Let me know if you require further information.
Thanks for you help!!!
I have a spreadsheet with two drop-down lists and two cells to fill in and this populates data in a table so that a journal entry can be entered into the accounting software.
The drop-down lists consist of the following:
1. Type = Annual or Prorated
2. Month = months of the year showing first three letters of the month
I have figured out how to calculate the prorated amount per month but I am struggling on how to calculate the annual amount. The annual amount depends on what month is selected in the month drop-down list, and of course annual being selected in the Type drop-down list. For each account that I have listed in column B, if annual is selected, and say for example JUL (July) is selected in the month, I want everything from April to July included in July's data and all other month's going forward to have their prorated amount.
Here's an example for you:
If the data was stating the following for each month: April = 1, May = 2, June = 3, etc. until March = 12. If I select July in the month drop-down list, I would want July's data total to be 10 (1+2+3+4) and August to March to show their correct amounts (i.e., 5 to 12).
I would be very grateful if someone could help me with this. The solution can be macro or formula generated, I have no preference.
Let me know if you require further information.
Thanks for you help!!!
