**How To Use Goal Seek In Excel For Multiple Cells**. Writing the goal seek macro. I have used quite a bit of algerbra to get to this point.

It is compatible with microsoft excel 2007 to 2021 and office 365. I am wanting to goal seek in one set cell by changing the values in multiple cells. K = j +295 cells(k, j).goalseek goal:=2, changingcell:=cells(j, j) next j end sub.

### The Macro Will Be Called, Gsmulticolumns.

In excel for mac 2011: Go to visual basic editor and insert a module. In the set cell box, enter the reference for the cell that contains the formula that you want to resolve.

### Column Y = Sum (W35:

There are three values here we need to input. One of the shortfalls of the goal seek tool is that you can only change one input cell at a time to affect the answer. The subroutine below use goal seek to make c2:c6 equal to 2 by changing b2:b6.

### Excel Can't Find A Solution.

Goal seek with multiple input cells. Set up your data so that you have a formula cell and a changing cell dependent on the formula cell. Sub macro1() for j = 2 to 6 cells(j, c).goalseek goal:=2, changingcell:=cells(j, b) next j end sub.

### Goal Seek Requires A Single Input Cell And A Single Output (Formula) Cell.

Use goal seek to find the input value that produces a formula result of +0.25. Go to the data tab > forecast group, click the what if analysis button, and select goal seek…. I am wanting to goal seek in one set cell by changing the values in multiple cells.

### Select The Range Which The Set Cells Will Be Changed To 3.

In the goal seek dialog box, select b6 in the ‘ set cell.’. How to use goal seek in excel for multiple cells. Use goal seek to find the input value that produces a formula result of +0.25.