T
trainguy
Hi all. Hopefully someone can point me in the right direction on this:
I have a complicated series of interrelated calculations, and I need to
use Goal Seek to modify the inital input in order to achieve a specific
result. That's easy. However, I want to be able to do this to an
entire range of cells.
i.e Set (v39:v256)=0 by changing (e39:e256)
is there a macro or other solution that will allow me to do that?
Note that the result cels (v39:256) are the result of a series of
calculations too complex to 'back engineer', so to speak, so I can't
just enter a formula in there.
Thanks for the help!
I have a complicated series of interrelated calculations, and I need to
use Goal Seek to modify the inital input in order to achieve a specific
result. That's easy. However, I want to be able to do this to an
entire range of cells.
i.e Set (v39:v256)=0 by changing (e39:e256)
is there a macro or other solution that will allow me to do that?
Note that the result cels (v39:256) are the result of a series of
calculations too complex to 'back engineer', so to speak, so I can't
just enter a formula in there.
Thanks for the help!