Hi, is there is a simple macro for the following:
Say I have random numbers in cells a1..a10, with formulas that feed off these random numbers in cells b1..b10.
Everytime I "F9" the a1..a10 random numbers regenerate and the formula recalculates values in b1..b10.
What I would like to achieve is to specify a number of simulations, say a maximum of 100 and have the results of these recorded in a separate sheet for each generation.
In other words instead of me pressing F9 100 times and copying and pasting these results can the process be automated - I'd like to record the both the random numbers and results for that selection in the separate sheet.
Thanks!
Say I have random numbers in cells a1..a10, with formulas that feed off these random numbers in cells b1..b10.
Everytime I "F9" the a1..a10 random numbers regenerate and the formula recalculates values in b1..b10.
What I would like to achieve is to specify a number of simulations, say a maximum of 100 and have the results of these recorded in a separate sheet for each generation.
In other words instead of me pressing F9 100 times and copying and pasting these results can the process be automated - I'd like to record the both the random numbers and results for that selection in the separate sheet.
Thanks!