I need Excel to run through some scenarios (very simple for loop).
After each scenario, I need an output worksheet to export data to a new workbook (workbook won't exist prior to running this macro). Each scenario should output to a new/different worksheet in the same workbook. At the end, the new workbook should contain multiple worksheets and be saved and closed. The excel file I uploaded has a partial macro that might be helpful in describing what I need.