+ Reply to Thread
Results 1 to 3 of 3

Loop starting at a specific row then adding value in the corresponding column backwards!

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Loop starting at a specific row then adding value in the corresponding column backwards!

    Happy Turkey Day,

    I am looking to build a macro that will loop down a column and when it finds a particular string, it will start adding values backwards ( towards the top of the page) from a corresponding column in that row.

    In my attached spreadsheet...I would like the loop to go and find the first instance of the string "bos" in column c and from there... start adding the value in Cell i13 to cell f12 and posting the result in g12 and then the value in g12 is added to the value in f11 and that result is posted in g11 so on and so on...all the way to cell g2.


    Let me know if there is additional clarification needed. it would be a big help to see how you guys would approach this with loops.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Loop starting at a specific row then adding value in the corresponding column backward

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Loop starting at a specific row then adding value in the corresponding column backward

    I'll experiment with that. Thank You sooo much

+ 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. [SOLVED] For loop backwards
    By grkchakri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 07:49 AM
  2. Loop for adding specific worksheets in specific workbooks
    By pankaj8219 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2013, 10:22 AM
  3. [SOLVED] Set Loop Backwards
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2013, 02:21 PM
  4. loop backwards for searching a string
    By abhimaan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2012, 02:06 AM
  5. Adding length to For Next loop after starting
    By alcarl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2012, 02:41 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