Is there a function I can use to solve a formula so that one cell equals
another cell by changing another cell. I have found the solver function which
allows me to change a cell so another one equals a fixed number which has to
be typed in, however I have hundreadsd of lines and don't want to have to
type in the number to solve for but just refer to a cell.

The company that makes the solver tool for Excel has a more robust version of
their software, at www.solver.com, which may do what you're looking to do.

Dave
--
Brevity is the soul of wit.


"Ben" wrote:

Is there a function I can use to solve a formula so that one cell equals
another cell by changing another cell. I have found the solver function which
allows me to change a cell so another one equals a fixed number which has to
be typed in, however I have hundreadsd of lines and don't want to have to
type in the number to solve for but just refer to a cell.

Hello, Ben!
You wrote on Fri, 20 Oct 2006 08:50:02 -0700:

B Is there a function I can use to solve a formula so that one
B cell equals another cell by changing another cell. I have
B found the solver function which allows me to change a cell
B so another one equals a fixed number which has to be typed
B in, however I have hundreadsd of lines and don't want to
B have to type in the number to solve for but just refer to a
B cell.

Basically, I think the Excel process is "Goal Seek", which does
just that. Check HELP but I don't know how to use it for several
cells automatically. Perhaps it could be handled by VBA.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Ben,

Instead of typing the number in each instance of Solver you can have it
in a separate cell. Then use a third cell =TargetCell-Value. Use the
third cell as target cell in solver and always ask it to be 0.

Does this help?
Kostis Vezerides


Ben wrote:
Is there a function I can use to solve a formula so that one cell equals
another cell by changing another cell. I have found the solver function which
allows me to change a cell so another one equals a fixed number which has to
be typed in, however I have hundreadsd of lines and don't want to have to
type in the number to solve for but just refer to a cell.