Multiple goal seek ?

Hey,

I have been searching for this (probably VBA code) over the internet for a long time, i hope that somebody can help me with it.

I need to apply Goal seek to solve a value based on a criteria on same row then when it finishes solving, it turns and solve for the next row and so on. ie applying goal seek for a range.

(As per the screen shot attached, I want to solve for the value F6 then when solved, i need to automatically solve for F7 , and so on )

I am really more than a newbie VBA codes so if someone can explain in details that would be really appreciated.


Thanks in Advance

Joe