Generate Payment List

[Ricksterr94]

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

[sktneer]

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

[Ricksterr94]

You are right, my apologies. Here is the correct file!
Example.xlsx

Would you know how to do this?

[sktneer]

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

[Ricksterr94]

Thank you for taking your time to help me. I really appreciate it.

I updated my excel file, please have a look and I explained it better in that file
Example.xlsx

[sktneer]

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

[Glenn Kennedy]

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.

[Ricksterr94]

Wow thank you so much! you two are legends, Sktneer and Glenn Kennedy. This solved my problem! I appreciate it greatly! Made my day

[sktneer]

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.

[Glenn Kennedy]

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.

[newdoverman]

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:

Please Login or Register  to view this content.

Column I:

Please Login or Register  to view this content.

Column J:

Please Login or Register  to view this content.

Column K:

Please Login or Register  to view this content.

Column L:

Please Login or Register  to view this content.

[newdoverman]

This version to be ignored.

[Ricksterr94]

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

Please Login or Register  to view this content.

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

[newdoverman]

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.