VBA Goal Seek

[ttran123]

I'm still new to this but can someone help me how to set goal seek "set cell" must be in ascending


For example cell B83 "set cell" is the sum of B71:B82 (must be ascending)

and cell B85 is the "to value"

and cell b70 is "by changing cell"


also, cell b71 is a hard code cell
cell b72 =B71*(1+$B$70)
cell b73 =B72*(1+$B$71)

and so far


thank you

 

[shg]

Have you tried recording a macro?

 

[ttran123]

I want get the whole thing automate for future uses. I want to assign that code to the button so that way i font have to redo the goal seek every time






A B C D
1 % % % %

2 Hard code in =A12*(1+$B$1) =B12*(1+$C$1) =C12*(1+$D$1)

3 =A2*(1+$A$1) -//-

4 =A3*(1+$A$1)

5 =A4*(1+$A$1)

6 =A5*(1+$A$1)

7 =A6*(1+$A$1)

8 =A7*(1+$A$1)

9 =A8*(1+$A$1)

10 =A9*(1+$A$1)

11 =A10*(1+$A$1)

12 =A11*(1+$A$1)

13 =sum(A2:A12)



14 ANSWER




So, i think i will need to go 4 goal seek.I want cell A3 to be greater than A2 and so on. Then B2 greater than 13 and so on.


Set cell = A13
To value = A14
By changing= A1

Set cell = B13
To value = B14
By changing= B1


Set cell = C13
To value = C14
By changing= C1

Set cell = D13
To value = D14
By changing= D1

 

[ttran123]

file:///C:/Users/Frisco_Local/Desktop/123.GIF

 

[shg]

Don't follow that.

Again, have you tried recording a macro?

 

[Joe4]

file:///C:/Users/Frisco_Local/Desktop/123.GIF

We cannot see files on your computer.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[ttran123]

sorry I'm new to this forum.

Let me ask a different question. Is there anyway to set the "by changing cell" to be non negative ?

 

[shg]

No, and no way to impose any other constraints using Goal Seek. That would require Solver.

 

[ttran123]

okay thank you. Follow up question is there any way i can do greater than but not equal to on Solver

 

[shg]

No. <=, =, or >=