Quarterly or half yearly cash flow

[sing_ideas]

without vbcode

Hi,
I have first 4 columns which i can change...Income, frequency, start date, end date

Cash Flow.xlsx kindly see the attachment


AFter entering the amount, changing the frequency column to Monthly, Quarterly or Halfyearly using drop down,
I want the respective rows to be filled with the "amount" automatically at...

0 month interval for monthly or
3 month interval for quarterly or
6 month interval for half yearly or
12 month interval for yearly...

... in the columns of the respective rows.

is it possible withOUT vbcodes.

regards
Singaravelu S"

[sing_ideas]

I managed to fill the column with the start date and end date for monthly payments, got struck with other frequencies like quarterly, Half yearly or Yearly payments modes