Title: How to Use Goal Seek on Multiple Cells in Excel
Are you tired of manually changing values in multiple cells to reach your desired outcome in Excel? Goal Seek can help! In this video, I'll show you how to use Goal Seek on multiple cells to quickly and accurately achieve your desired results.
First, I'll demonstrate how to set up the spreadsheet with the input values and formulas that you want to adjust using Goal Seek. Then, I'll show you how to use the Goal Seek tool to find the values needed in multiple cells to achieve a specific result.
Whether you're an Excel beginner or an advanced user, this video will provide you with the knowledge and skills you need to use Goal Seek on multiple cells in Excel. So watch now and take your Excel skills to the next level!
Below is the script used in the Macro:
---------------------------------------------------------------
Sub GoalSeekWithMultipleCells()
Dim J As Integer
For J = 4 To 15
Cells(J, "E").GoalSeek Goal:=Cells(J, "G"), ChangingCell:=Cells(J, "D")
Next J
End Sub
----------------------------------------------------------------------------------
Regenerate response
