Excel numericall Solver

[billywhiteshoes]

Hi-

I use excel numerical solver add-in and spread sheet I downloaded here:

http://puccini.che.pitt.edu/~karlj/C...01/solver.html

excel will numerically calculate two unknowns (in cells A2 B2) in two equations with input of two known values from my spreadsheet. Currently, I have to do this individually (for every set of 2 input values) by manually changing the cell references for the input values and press "solve" every time.

"Control D" does not work. When I press solve on the data toolbar, the solver window brackets the two cells $A$2, $B$2 (where my solutions appear thater to satisfy the two equations). I can't find a way to get solver to "control D" and work it's way through my set of two known input values.



Can anyone help?

[Alf]

http://support.microsoft.com/kb/843304

Could perhaps be of help.

Alf