Formula required for Cost distribution over a period for current as well as future years

[rehana402003]

Hello All,
I am using Excel 2013

I have a budget sheet where the value needs to be distributed over the current year as well as the future years
I have attached a sample for explanation

I need a formula which should look for the value in Col which can be A or H

If A it should fill up the values using a formula under Columns J to M. Columns N to Q would be blank
If D it should fill up the values using a formula under Columns N to Q. Columns J to M would be blank

My objective to get proportional values depend on the current month and the balance remaining in that year

In the sample I have shown two different rows for Values A and D for explanation

I need a single formula which should change according to the Values A and D in Column H
Hope to get some help
TIA
Rehana

[rehana402003]

Dear All,
If formula is not possible then I am ok with VBA to solve this problem.
The data is shown only for one row. Actual data is big

Thanks once again for your time
Rehans

[JeteMc]

This proposal populates J1:M1 and N1:Q1 with the letters A and D respectively and then hides those letters by setting the font to white.
The formula used to populate J3:Q4 is:

Please Login or Register  to view this content.

Let us know if you have any questions.

[rehana402003]

Thanks a lot
You folks are really a great help to all of us
Post marked Solved