+ Reply to Thread
Results 1 to 7 of 7

Create Loop and stop when done

Hybrid View

whtwzzrd88 Create Loop and stop when done 07-20-2013, 06:46 PM
Tinbendr Re: Create Loop and stop when... 07-22-2013, 11:12 AM
whtwzzrd88 Re: Create Loop and stop when... 07-22-2013, 03:10 PM
Tinbendr Re: Create Loop and stop when... 07-22-2013, 03:56 PM
whtwzzrd88 Re: Create Loop and stop when... 07-22-2013, 05:03 PM
whtwzzrd88 Re: Create Loop and stop when... 07-22-2013, 05:04 PM
whtwzzrd88 Re: Create Loop and stop when... 07-31-2013, 05:54 AM
  1. #1
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Create Loop and stop when done

    Quote Originally Posted by whtwzzrd88 View Post
    I have figured out how to everything but the loop part.
    I think you should have two loops. The one I listed was the list at B29:B35. So the loop will iterate each cell, but what we need to add is the Range.Find do-loop.

    Does each one in the list only appear once in the A18:Y25? (or should that be K25?)

    Where is the data being pasted to?
    David
    (*) Reputation points appreciated.

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 365
    Posts
    29

    Re: Create Loop and stop when done

    Its a log book. Every time he does a burn, he writes how long the burn takes. It is guaranteed that he will do multiple burns in one day. So each one will appear multiple times.

    Everything is getting pasted to Data sheet.

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 365
    Posts
    29

    Re: Create Loop and stop when done

    All I'm trying to do is keep track of how long altogether the burns took, how long repairing equipment took, etc.

+ 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. Can't get my loop to stop!!
    By berlinhammer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2009, 03:04 AM
  2. How to stop the for loop?
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2008, 07:33 AM
  3. Loop until won't stop!?
    By meacho in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2007, 03:37 PM
  4. Hot key to stop a LOOP
    By joopdog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2006, 02:51 PM
  5. Stop a loop
    By Matthew McManus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2005, 04:55 AM

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