Goal seek repeated in many columns

T

Tom Keresztes

I am building a spread sheet that needs goal-seeker to find changes that satisfy a condition. This needs to be repeated in many columns; say about 36. Doing it by hand is not optimal. Is there a way to make this operate across a spread sheet? Each column has the same layout

I suppose a macro would do it, but is there another way?
 
J

Jay

=?Utf-8?B?VG9tIEtlcmVzenRlcw==?= said:
I am building a spread sheet that needs goal-seeker to find changes
that satisfy a condition. This needs to be repeated in many columns;
say about 36. Doing it by hand is not optimal. Is there a way to
make this operate across a spread sheet? Each column has the same
layout.

I suppose a macro would do it, but is there another way?
Click to expand...

I have a similar need. Did anybody reply to you privately, perhaps?
 
Top