# Solve / Goal seek problem

#### brites

##### Board Regular
SOS!!!!
URGENT MATTER!!!!

Hi folks,
here`s the deal:
I have to do a simple goal seek to find an answer (5%) for cell (lets say) Y8, only by changing the "price" cell O8. Ok, so far no problem...
the tricky part is that I have to do the same thing from cell Y9 to Y212 (changing its correspondent cell in Column O), for 13 different sheets.
Is that anyway I can replicate the goal seek/solve function automatically?
Or I will have to do it one by one???

Brites.

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
If you need to have the corresponding cells in column Y contain 5% of the value in the cells in column O, then:
In cell Y8, enter: =O8*5%
and copy down to Y212. Done!

C'mon u kidding right?

Thx anyway....

What you are saying is you have essentially several hundred goal seeks to do?

Brites wrote:
" have to do a simple goal seek to find an answer (5%) for cell (lets say) Y8, only by changing the "price" cell O8. Ok, so far no problem... "

As I understand it, you have any number of prices in the range O8:O212, and you want to have 5% of the coresponding prices in Y8:Y212.

If that is the problem, then, my solution, above, is correct. Just enter=O8*5% in cell Y8, and copy down. But, pehaps I am not understanding what is needed?

Yep, thats right... several hundreds...
i tried to make it via macro but i couldnt get it done...

any ideas?

OK! Finaly I GOT IT DONE:

Dim sv As Double
Dim n As Integer

Sub Macro2()
sv = Cells(4, 155)
For n = 8 To 271
Range("EY" & n).GoalSeek Goal:=sv, ChangingCell:=Range("EO" & n)
Next
End Sub

Replies
0
Views
96
Replies
6
Views
640
Replies
5
Views
739
Replies
1
Views
651
Replies
3
Views
259

1,221,241
Messages
6,158,727
Members
451,512
Latest member
aimarhu

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back