Is it possible to run a solver on multiple target cells, i.e. to solve cells A1:A10 to all equal 100 by changing all of B1:B10?
To make matters worse, this is a [deliberately] circular model...
Any suggestions gratefully received.
Unfortunately, I can't attach the file, so this will have to be an abstract question.