You're right, sorry! I'm going to delete it from here since it's better explained in the other place and don't want people to waste their time.
Thanks! I'm working on it, because I found I need to add an additional step to the process since the list of numbers are not exactly consecutive (there are 1500 number, but just 1399 rows). Find the problem better explained here:
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
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!!