I am looking to build a dynamic range(I think I need this). Under the assumptions tab, I have the loan listed in Column A and Months remaining in column B. As you can see I built a list for each loan(58 total). The issue now is that, I plan on having many more loans and I figured it would be smart to learn dynamic range. I have looked at it online, but I am unsure as to how I should implement it. The sheet, default database calculates the maximum number of months remaining. For example, Loan 1 only goes to 56, so cell B3 of Assumptions has the range go up to 56. I want this similar logic to apply to all the loans below. I have only done to loan 58, but would prefer to use dynamic range. Thanks for the help. If any questions, feel free to ask. Thanks again
Bookmarks