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.