Post by ElysMustache on Apr 15, 2013 1:17:23 GMT -5
I'm working on a project, evaluating game data.
Here's what I want to do: 1. Generate random number 2. Do some math with it 3. Output the results, all in one row 4. Recalculate the spreadsheets (basically, just refresh the random numbers) 5. Have new results 6. Do this about a thousand times 7. Put all the results from these thousand iterations in a separate spreadsheet
Need help with step 7. What I don't want to do is hit refresh (CTRL+SHIFT+F9), and then copy and paste the results manually a thousand times.
Any ideas? Let me know if clarification is needed. Thanks.
edit: In other words, every time I recalculate the spreadsheet, I want to append the results to a file, preferably a spreadsheet.