+ Reply to Thread
Results 1 to 2 of 2

Count until reach some number and copy that row's information then loop

  1. #1
    Registered User
    Join Date
    01-18-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    2016
    Posts
    1

    Question Count until reach some number and copy that row's information then loop

    Hello, I would like some help here.
    The problem is : I'd like to count "Orange" to 36 units and then copy the the 36 unit's "Date" and "Time" to the right-hand box. Then continue counting until the remaining orange are not enough to reach 36 unit and "display how many unit of orange left" and also copy "Date" and "Time" in the remaining box.

    I just started to learn VBA last week. I think im still beginner level. Thank you in advance.

    Help.png

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Count until reach some number and copy that row's information then loop

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. Replies: 13
    Last Post: 07-08-2018, 05:22 AM
  2. [SOLVED] copy range & paste every 3rd row after endlast row loop till date reach 31/11/2014 in colA
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2014, 06:58 AM
  3. Loop Do Until Reach a maximum value
    By n_ant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2013, 03:23 PM
  4. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 PM
  5. Replies: 4
    Last Post: 03-25-2009, 10:12 AM
  6. reach previous value in a loop
    By 77anders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2009, 02:50 AM
  7. Count number to reach a cumulative value
    By Bruce in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2005, 02:06 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