I have a sheet with a simple macro to randomize a sequence of returns, and display the results. There is a button to run the macro once, and only one macro in the sheet. The results I want to record are in F4:T4 Here is the sheet: [login to view URL]
I want a simple script to run this simulation repeatedly (I would select the number of times, likely 50-1000, collecting each set of results as a new row on the another tab. I'd like a header section on the new tab that is showing me some statistical analysis of these results - average obviously, but maybe a couple other simple analysis as well Median? Std Dev? (not too worried about that part, and I could add those later). Main thing is the script to run these sheet multiple times and display the results.
I think this is a very simple job, just would like someone to whip it up for me