Hi! I have an Excel spreadsheet with lots of mathematical calculations. I want to repeat the same set of calculations 1000s of combinations by varying certain input parameters and getting a set of output results. I am creating one row of input/output results for each set. In the end I will get 1000s of rows of analysis results. I will then plot some of them as x-y graphs for various I/O combinations. I have labeled each run with a case number. Currently I am manually running each case & copying the results in one row. That is slow & tedious. How do I automate the process?
