+ Reply to Thread
Results 1 to 4 of 4

Macro with loop and waiting time

  1. #1
    Registered User
    Join Date
    07-17-2020
    Location
    Madrid
    MS-Off Ver
    2019
    Posts
    1

    Lightbulb Macro with loop and waiting time

    Hello!


    I'm new here, so thank you in advance to invest time on this.


    I have a task I need to replicate 1,339 times, and wanted to use a Macro to do it, but can't find the solution. What I need is to do is:

    Copy 'A2' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G2' of 'Data dealers'

    Then, repeat this process going down:

    Copy 'A3' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G3' of 'Data dealers'


    Copy 'A4' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G4' of 'Data dealers'

    ....


    Copy 'A1340' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G1340' of 'Data dealers'



    Is there any way I could do it with a Macro?


    A million thanks in advance!!

    Ed.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Macro with loop and waiting time

    Welcome to the forum.

    Cross posted: https://www.ozgrid.com/forum/index.p...-waiting-time/


    Please see Forum Rule #3 about cross-posting. Read this to understand why we (and other sites like us) consider this to be important.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Macro with loop and waiting time

    May I ask why you wouldn't just copy A2:A1340 in one go, then wait, and then copy G2:G1340?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Macro with loop and waiting time

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Loop not waiting for calculation before proceeding
    By Another Fool in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2019, 09:11 PM
  2. Waiting for Query to be executed - waiting forever!
    By BHeup in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 07-01-2018, 11:52 PM
  3. [SOLVED] VBA Solver Loop while waiting to complete
    By richardking in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-16-2017, 10:52 AM
  4. [SOLVED] Calculating average waiting time over the last year?
    By Gio291 in forum Excel General
    Replies: 8
    Last Post: 11-10-2016, 09:34 AM
  5. [SOLVED] Calculating longest waiting time at given time slot
    By dvs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2013, 06:20 PM
  6. Waiting time calculation
    By mojupe in forum Excel General
    Replies: 2
    Last Post: 07-03-2011, 03:00 AM
  7. Calculating a waiting time
    By jack.williams in forum Excel General
    Replies: 1
    Last Post: 01-12-2010, 12:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1