+ Reply to Thread
Results 1 to 1 of 1

60 USD Need to insert rows based on conditions up to a certain date. Re-run For Loop? Help

  1. #1
    Registered User
    Join Date
    02-14-2015
    Location
    Chicago, USA
    MS-Off Ver
    2013
    Posts
    21

    60 USD Need to insert rows based on conditions up to a certain date. Re-run For Loop? Help

    Hello All,

    I have the code below that uses a For Next loop to insert rows given specific conditions working from the last row up. However, I really need to insert as many rows every 30 days as necessary in the same manner up to a certain date or condition - that is, I do need to skip up through the rows but in order to make all the insertions that are necessary, I would need to have the For Next loop run more than once or something of that nature.

    Essentially, rather than inserting one row per save given the conditions, as the code does now using a for loop, I need to insert all perfect point rows withing valid date conditions (as if the For loop were repeating its row scan until conditions stop it from repeating).

    I have looked high and low to this point for a solution and keep either confusing or crashing the macro. Please help me see the error of my ways? Will reply to any questions. Thank you...

    Please Login or Register  to view this content.


    Paypal to Ozgrid Unique Transaction ID # 49P9309681906281V
    Attached Files Attached Files

+ 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. Need to insert rows based on conditions up to a certain date. Re-run For Loop? Help?
    By treschouette in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2015, 03:04 PM
  2. Insert rows in conditions
    By chris4204 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2015, 04:13 AM
  3. How to insert rows+add based on the conditions
    By RookieOfTheYear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2012, 09:45 AM
  4. loop through rows for match insert blank rows with title
    By reeyu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 07:34 AM
  5. Loop based on a couple of conditions
    By h_aesa1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-31-2010, 01:22 PM

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