I am new to trying to programming with excel. I am trying to gather some statistics on random numbers generated by a worksheet. Here is what I would like to do:
I would like to be able to use one sheet to call on another sheet to recalculate itself a specified number of times (up to 10,000) and after each recalculation to save one of the cells on the recalculating sheet.
In other words, In the 1st worksheet I would get 10,000 cells of the results of the 2nd worksheet calculation that I could then run some simple statistics on.
Is this possible? Is there a simple way to do this? I have very little experience!
Thanks for the help!