How to run worksheet multiple times changing a single input?
I have a worksheet with an input at cell J2, many calculations, and a series of outputs at cells K4167:Z4167.
I want to run the worksheet several hundred times for different values of the input and produce a table showing the outputs for each input.
How does one do this in Excel?
Thank you.
|