Hello,
I have a script file that runs a simulation by using random data to forecast future values. I'm using a for loop to repeat this calculation around 100 times. Each iteration results in a column with 50 rows of data. I made a script to copy the results from the final iteration to another worksheet, however I need help with making a script copy the data from each iteration and place them in columns next to each other in a different worksheet.
This is the script I use to copy the final iteration. It only copies the final iteration because it rewrites the last iteration on top of the previous iteration.
Sheets("Loop").Range("K1:K50").Copy
Sheets("Compilation").Activate
Sheets("Compilation").Range("A1").PasteSpecial xlPasteValues
Any help would be greatly appreciated.
Thanks!
Bookmarks