Hey guys,

Thanks for your assistance.

I'm having some problems still with the Macro thing (first shot at it). I
basically just "started recording a macro", performed the solver task (i.e.
Tools Solver Set Target Cell etc. Solve) then "stopped recording". I
saved the worksheet, then tried to run the macro and got the following:

<img src="http://img136.imageshack.us/img136/8928/excelscreenshotog7.png"

Does this make sense to you?

Apologies for my naivety.

Again, appreciate your help!

Cheers,

James.




"Dave F" wrote:

You could also attach the macro to a button which you can place on your
worksheet directly. Then when you click the button the macro will run, which
triggers the Solver tool.

To get a button on the worksheet, show the Forms toolbar, draw the button,
right-click on the button icon, and assign the macro you recorded to the
button via the dialog box that appears when you right-click.

Save everything and see how it works.

As Scott suggests, it's a good idea to experiment with this on a backup copy
of your workbook until you're sure that XL is doing what you want it to do.

Dave
--
Brevity is the soul of wit.


"Scott" wrote:

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