This is not available by default but is easy to implement. The macro record functionality is found in the developer tab in the ribbon. This will be semi-technical but through this style of development we can focus on the process and the concepts instead of focusing on how to write code. Then we will create a loop to dynamically select and replace these values and run the solver again. We will then identify the key pieces of code to change. The record macro tool will allow Excel to convert our manual steps into VBA code. We’ll leverage the macro recorder in Excel to handle most of the actual code. By the end you’ll be able to automate any of your own personal models and scale your analysis. In this article we’ll go in depth from start to finish covering the concepts and methods step by step.
There was a brief explanation in the previous article, but nothing dedicated to how to implement it from start to finish.
