Help with creating a dump file that stores values from a scenario sheet.

[Chuck3]

Hello all,

I am not sure if this is possible, but I have referred to this forum many times for help, so I thought I should ask for an expert opinion. Also, if I'm in the wrong forum, please let me know.

I have the attached spreadsheet that I use for testing various scenarios based on a bunch inputs. Once I have entered in the inputs, I record (manually) the results returned from the formula cells, clear the input cells and repeat the process for my next scenario.

I would like to set something up where upon pressing a button, the input cells are cleared (ready for the next scenario) and the inputs and results that were generated are dumped to another sheet which stores each new scenario’s info in a new column, even though I have cleared the scenario sheet. Ideally, the Dump sheet should be a separate workbook from the Scenario workbook. That way I have a master record of all the scenarios for a particular Simulation and the results on 1 sheet which can be email or reviewed at a later date.

Any help would be GREATLY appreaciated.

Thanks
Chuck