Hey there.
I am trying to make a dynamic chart based on an amortization schedule. The only problem is the data is dynamic, with the number years of the loan and the frequency of payments can both be changed.
So if someone enters a 10 year loan with yearly payments I get a table with 10 rows but if they are calculating a 20 year loan with weekly payments there would be 1040 rows.
I have to admit that how I got this working probably isn't the simplest method, but with my level of knowledge it was the best I could do.
I have attached the spreadsheet on the off chance someone is willing and able to help.
Project_Part2.xlsm
Barry
Bookmarks