Goal Seek vba for multiple rows

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