Increase a cell value until another cell value is matched

HI,

I am looking to increase a single cell value from 0 up to 1000 automatically. This cell is linked to a formula that changes another cell. When this other cell hits a certain value i wish the first cell to stop and show me the figure.

So for example:

A1 - This is my cell that will start at 0 value
A2 - Has a static value in it - example - 2500
A3 - This cell always starts at 1000 and increases when A1 is increased.

We start to increase cell A1 by multiples of 50 and then this increase A3 at a set rate. When the A3 value matches the A2 static value (2500) then the calculation is completed and i can use the value in A1.

Is their a way to write a macro (or formula) to automatically increase A1 until A3 matches A2.

Any help on this would be much appreciated.

Simon,

HI,

Sorry for the bad explanation above. I have attached the file which should make it so much easier.

basically just adjust B12 until B10 and B11 match each other. The value for the example is 2980 needs to go into B12.

Appreciate any help on this as i will have lots of these sheets where i need to enter in a number into B12 until B10 and B11 MATCH.

VBA routine is the best approach i think, i would be happy to use that.

I've set up a solver model based on your uploaded file. Solver if installed is found in the "Data" tab. The setup in this case is quite simple.

Solver only need to be told what cell to change i.e. B12 and that the constraint is that B10 = B11 and then click "Solve"

Alf