Gregg Wolin
Member
I have a model that includes a construction loan that requires an interest reserve be included in the overall loan budget. The model calculates the total projected interest based on this budget (cell A2), and using this value as reference, I manually add the interest reserve amount to the budget (cell A1), which then changes the value of cell A2. I manually play with the Value of A1 until it is equal to the value in A2. I'd like to create a macro that will automatically optimize the interest reserve in A1 so that it equals that in A2. The traditional Goal Seek function won't work in this instance because if requires that you have a fixed target to solve to.
I suspect that a DO UNTIL loop that sets the value of A1 to $1, checks to see if A1=A2, and if not, adds $1 to A1 and checks again, etc.
Any help would be appreciated.
I suspect that a DO UNTIL loop that sets the value of A1 to $1, checks to see if A1=A2, and if not, adds $1 to A1 and checks again, etc.
Any help would be appreciated.