SantasGotAbrandnewbag
New Member
- Joined
- Jan 27, 2015
- Messages
- 1
Hello all, I have a very specific problem that I am uncertain how to solve. I have set up a Monte Carlo simulation to display an average of 2000 weeks of randomized data, so every time I hit F9 it updates. However, I would like to be able to get an average of my average for every time that I have hit F9. So if the average was 100, then replaced by 98, then by 97 when updating, I would like to have a running average of all the updated numbers.
Is this possible with VBA?
Any help would be appreciated, it would save me a lot of time.
Is this possible with VBA?
Any help would be appreciated, it would save me a lot of time.