#Goal seek excel how to#
You can make it visible by enabling from Excel Options > Customize Ribbon.įor more details see How to display the Excel Developer tab for using advanced features.
and use this recording as a VBA cheat sheet.įirst, you will need to access the Developer tab in the ribbon. If you're not familiar with this concept, a macro is a feature that creates a VBA code. The easiest way of using VBA is by recording a macro. The only way to automate Goal Seek is using VBA. We can find the value of the input1 with Goal Seek. Let's assume the input2 is equal to 3, and we want the output to be 39.