Run Goal Seek automatically

Copper Contributor

How can I make Goal Seek run automatically to match a cell value to a different cell value by changing a third cell value?

 

For instance....in my particular spreadsheet, I want to run Goal Seek on K24 and make it match a calculated value in D48 by changing the value in D50.

 

 

0 Replies