Generate Payment List

Dear community,

I have been struggling with this issue that I am having for 2 days and really need some help. I have done a lot of researching but I can't get it right.
I am trying to create a payment list which shows all my payments of for example 2014. However, the data that I want to enter myself is ofcourse very limited. All I want to enter is what type of Payment it is, the start date, the term and the amount. I want excel to generate a list based on that information. This itself is doable for me, however when I need to add an additional payment, I seem to struggle to get a good formula which will generate a list containing both payments.

I have attached the excel file below so you have an idea what I am talking about. Could someone please help me?
Example.xlsx

Kind regards

I think you have attached the wrong workbook otherwise the attached workbook doesn't match with your description.

You need to explain it more. The dates in the table and in the list are not matching. Highlight your desired output.

Please find the attached sheet to see if this works as per your requirement.

Sktneer has provided you with a good solution! I have just taken his work & extended it to cover the other rows that were covered by your Table.

You're welcome. Thanks for the feedback.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

You're welcome. Can you mark the thread as solved and (preferably) also click the Add Reputation button at the foot of the post(s) of all those who helped.

This is my "kick at the cat".
I started the data in column H so the references will be different from the other solutions:
Column H:

Formula:

=IF(IF(ROWS(H$3:H3)<=$E$5,A$5,IF(ROWS($H$3:H3)-$E$5<=$E$6,A$6,IF(ROWS($H$3:H3)-SUM($E$5:$E$6)<=$E$7,A$7,IF(ROWS($H$3:H3)-SUM($E$5:$E$7)<=$E$8,A$8,IF(ROWS($H$3:H3)-SUM($E$5:$E$8)<=$E$9,A$9,"")))))=0,"",IF(ROWS(H$3:H3)<=$E$5,A$5,IF(ROWS($H$3:H3)-$E$5<=$E$6,A$6,IF(ROWS($H$3:H3)-SUM($E$5:$E$6)<=$E$7,A$7,IF(ROWS($H$3:H3)-SUM($E$5:$E$7)<=$E$8,A$8,IF(ROWS($H$3:H3)-SUM($E$5:$E$8)<=$E$9,A$9,""))))))

Column I:

Formula:

=IF(H3="","",INDEX($B$5:$B$9,MATCH(H3,$A$5:$A$9,0)))

Column J:

Formula:

=IF(H3="","",INDEX($C$5:$C$9,MATCH(H3,$A$5:$A$9,0)))

Column K:

Formula:

=IF(H3="","",IF(H3=H2,EOMONTH(K2,1),EOMONTH(OFFSET(INDEX($A$5:$A$9,MATCH(H3,$A$5:$A$9,0)),0,2),0)))

Column L:

Formula:

=IF(H3="","",INDEX($F$5:$F$9,MATCH(H3,$A$5:$A$9,0)))

This version to be ignored.

Thank you for your reply Newdoverman. Your formula is great as well. However, I am not the greatest at deciphering formulas. Could you maybe explain what your formula does different to the ones mentioned above in terms of this formula

=IF(IF(ROWS(H$3:H3)<=$E$5,A$5,IF(ROWS($H$3:H3)-$E$5<=$E$6,A$6,IF(ROWS($H$3:H3)-SUM($E$5:$E$6)<=$E$7,A$7,IF(ROWS($H$3:H3)-SUM($E$5:$E$7)<=$E$8,A$8,IF(ROWS($H$3:H3)-SUM($E$5:$E$8)<=$E$9,A$9,"")))))=0,"",IF(ROWS(H$3:H3)<=$E$5,A$5,IF(ROWS($H$3:H3)-$E$5<=$E$6,A$6,IF(ROWS($H$3:H3)-SUM($E$5:$E$6)<=$E$7,A$7,IF(ROWS($H$3:H3)-SUM($E$5:$E$7)<=$E$8,A$8,IF(ROWS($H$3:H3)-SUM($E$5:$E$8)<=$E$9,A$9,""))))))

The other formulas that you did different are very useful in terms of the payment date etc! Thank you greatly

The first formula is not significantly different if at all from the other "first" formulas. It is the others that are different and probably useful to you.