I have created a calculation tab, on which I change a few manual inputs and get a different result. I need to create a macro that will store the results of each different scenario of inputs that I use on a summary or output worksheet (in the same workbook as the calculation). I don't want the first results to be over-ridden by subsequent calculations.
Help!