Goal Seek vba for multiple rows

[mmasonspg]

Hello,

I am very new to vba and do not know much at all. I have a worksheet where I would like to use Goal Seek and run it against the data row-by-row. I have Googled other examples and found solutions however I haven't been able to make the code work for my scenario as I'm not experienced enough to manipulate coding.

For data F4:H15, I would like to Set cell F4 to value G4 (another issue is I'm unable to 'select' G4 for this option without running a macro, I need to physically type this value in) by changing cell H4.

See attached for spreadsheet example.

Thank you for any help that anyone can provide!

MM

[Jacc]

I don't understand exactly what you want to seek and change to what but here is a macro. You can just use the name manager to change the named ranges to suit your needs.

[mmasonspg]

Thanks for your help Jacc - however I realize now that I provided misinformation.

Ultimately, I need F4 to equal G4. Unfortunately, the current macro you provided equates F4 to H4.

Since F4 = C4/I4, I need to goalseek a rate for I4 to divide C4 by.

I hope that makes sense.

Thanks again,

Mark

[mmasonspg]

Jacc, please ignore my previous post. I changed the GoalRange to column G and it worked.

Thanks again!

[Jacc]

It's nice when things work out according to plan!

[HelenO]

Do you need to use goalseek? Can't you get the same result using a formula in column I? (as in =C4/G4, which then makes F4 equal to G4)?