WIthout putting much thought into this, I'd recommend that the next
time you change the rate, you record a macro of you doing all the
alterations.

Tools - Macro - Record New Macro
Store the macro in the Workbook you're working on and rename it to
something suitable.

Once you've performed all the steps, stop recording.

Next time you need to use the macro, either go Tools - Macro - Macros
and choose the one you recorded. (Or hit Alt-F8 and choose it)

I'd recommend you save your file twice... and using the backup copy run
your macro with a new IRR to ensure that it does what you expect it to
do.

If you need more flexibility than that, we'll need more details I
think.

Scott

JamesB wrote:
Hello,

I really appreciate any help I can get on this somewhat complex issue. I
will try to be as clear as possible.

Essentially, I am currently using Solver to evaluate the repayment amount
needed to give a designated Net Present Value over a designated time period.
Unfortunately, the PMT function cannot be used as there is more than one
"lending" of funds over the term. For example, whilst the initial Present
Value (amount lent) of a 24 month term may be $1000.00, 12 months into the
term we lend another $500.00. We refer to this is "MultiDraws". Hence, we use
Solver to find the constant repayment figures neccessary to give the required
IRR over the term taking into account the future drawdowns.

The problem I have is this - we do this for COUNTLESS scenarios, and every
month when we adjust our rates (required IRR), not only do we change the
"rate" cell, but we also then have to re-run the Solver function on all the
different scenarios.

Ideally, it would be excellent if we could just alter the "rate" cell and
have the repayment figure AUTOMATICALLY solved. I guess what I looking for is
the ability to make SOLVER AUTOMATED... The conditions/parameters of solver
will be the same every time, I'm just looking for a way to avoid going Tools
Solver Solve OK on EVERY affected cell (an extremely drawn-out process).

Surely there is a simple way to make the solving happen automatically, as a
normal function would?

I really, really really appreciate any assistance on this matter.

Regards,

James B