Any way to set a cell to Auto Goal-Seek

[WoodfinAnalyst]

In a spreadsheet I'm using, one of the value's for a cell, should always be manipulated using a goal-seek to another cell.

i.e.
Cell A1 is value of B1/B2
B2 is = to C1/C2
In order to figure out A1, I do a goal seek, Set Cell A1 to Value 6, By changing cell C2.

Is there a way that I can set a formula or something along those lines to have cell A1 permanently be a Goal-Seek value?
So that anyone who just picks up the spreadsheet can have Cell A1 goal seek and change cell C2.

Thank you!

 

[pgc01]

Hi

Why don't you use a formula?

In C2:

=A1*C1/B1

 

[WoodfinAnalyst]

I guess I should have specified more, that's not the exact formula I am trying to figure out.

The one I am trying to figure out consists of about 30 other formula's figuring into different cell's just was trying to describe it in an easier manner.

 

[pgc01]

I guess I should have specified more, that's not the exact formula I am trying to figure out.

The one I am trying to figure out consists of about 30 other formula's figuring into different cell's just was trying to describe it in an easier manner.

I see. In that case, if you want to change C1 using goal seek, you need vba. Either a button or a worksheet change event.

You can easily test it.

Record 1 goal seek with the macro recorder. Insert a button and assign it the macro you recorded.

 

[mathmonkey]

I took 5 min of my life to register to this forum and say that i hate clever pple like you! Of course it's not THAT simple! I'm using sinh and cosh functions and also need sort of auto goal seek / solver in my sheet. Sometimes you jus't cant just solve for "x"

Hi

Why don't you use a formula?

In C2:

=A1*C1/B1