Posts by Et717



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