I am currently working on a simulation, and trying to create a macro that will record the results going down columns. The simulation is run and recorded with 2 data points in cells E1:F1. I would like to copy and paste those values starting in cells B1:C1 and going down based on 1000 simulations.
My question is, what macro would allow me to copy and paste cells E1:F1 repeatedly going down columns B:C stopping at 1000 trials?