I have loan calc & amortization table(starting balance,interest rate and start date) all set.
For further functions I will need to use some of this info and this is where I am stuck.
Since the User's will have different Loan Start Dates, the cell that reflects their Current Balance changes accordingly.
I need to figure out how to
a) locate the one cell that reflects their Current Balance("B18:B377")
b) have data transfer from "A1" into this cell. This cell is within "B18:B377" and has circular references since it is built in to the loan amortization table.
Thanks
For further functions I will need to use some of this info and this is where I am stuck.
Since the User's will have different Loan Start Dates, the cell that reflects their Current Balance changes accordingly.
I need to figure out how to
a) locate the one cell that reflects their Current Balance("B18:B377")
b) have data transfer from "A1" into this cell. This cell is within "B18:B377" and has circular references since it is built in to the loan amortization table.
Thanks