Is there a way to Goal Seek across a range of data points in Excel, instead of just a single value?

Normally, Goal Seek requires:

• Set cell
• To value
• By changing cell

But in my case, I have time-series data and want to apply Goal Seek to many rows at once, not just a single data point.

Ideally, I would:

• Select one formula cell as the set cell
• Provide a range of target values for “To value”
• Specify the corresponding cell to change

So instead of solving for one row, it would solve for a whole range of rows.

Is there a built-in way to do this, or do I need something like Solver, VBA, or a macro to loop through the rows?
Or, if using Solver, how best to do this?