dimanche 19 avril 2015

Excel-VBA: How to keep the data from Monte Carlo simulation results in the same chart?

Not sure if this is more of an Excel or VBA sort of question but here's my issue:


I'm looking into making something like the following, but can't find any information on how this can be done with VBA without copy/pasting each run to another spreadsheet.


Could someone please let me know if this is possible, or better yet, tell me what's the technical term for keeping the results from a dynamic range in memory and then plotting the results at the end so I can research it myself?


Cheers!


enter image description here


Aucun commentaire:

Enregistrer un commentaire