View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Keeping track of results of refreshed/updated data

Just to clarify that the "do 2 simulation runs" in the line:
.. Or, just set up 1 sheet x 50,000 rows and then do 2 simulation runs

means pressing the F9 key twice. Each press generates 50,000 iterations (it
will take awhile for this to complete). When complete, copy entire sheet
paste special values into a new sheet. Then press F9 again to run the next
50,000 iterations.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---