Macro Copy & Paste same Cells Down [Closed]

Report
-
Hi all,

First off, I'm new to macros so just a warning.

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?

Thanks in advance!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!