I have a task I need to replicate +1,500 times, and wanted to use a Macro to do it, but can't find the proper way.
What I need is to write number '1' in cell B2 -> wait 20 seconds (excel takes some time to run the formulas) -> copy cell B200 -> paste it in cell G2
Then, the same but writing number '2' in cell B2 -> wait 20 seconds -> copy cell B200 -> pase it in cell G3
That is to say, I need it to write consecutive numbers in cell B2, wait a few seconds, copy B200 and paste it in a colum from top to bottom.
Is there any way I could do it with a Macro?
Thank you in advance!!