Posts by Et717

    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


    Hello!


    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!!