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.