+ Reply to Thread
Results 1 to 10 of 10

Do Until Loop

  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    8

    Do Until Loop

    Dear all,

    I have managed to successfully use a do until loop, however once finished, I would like it to move to the next row and do the same thing.

    Appreciate any guidance.

    Thanks,
    Themd


    Please Login or Register  to view this content.
    Last edited by Themd; 07-20-2009 at 07:36 AM. Reason: making it user friendly and in line with forum rules.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Do Until Loop

    Welcome to the forum, Themd.

    Please take a few minutes to read the forum rules, and then edit your post to add code tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Do Until Loop

    Thank you.

    Can you post a sanitized workbook that shows what you're trying to do?

  4. #4
    Registered User
    Join Date
    07-16-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    8

    re: Do Until Loop

    I have a dataset for each Name by rows. However the data is in intervals of three. It has been collected every three months. What I would like to do is to interpolate the cells between two periods for the whole row. I have done it for one row, but I think I need an addition to the formula to make it go to the next row and repeat the same thing.

    Example is attached.

    Thanks,
    Themd
    Attached Files Attached Files

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Do Until Loop

    Try this:
    Please Login or Register  to view this content.
    Last edited by shg; 07-17-2009 at 03:31 PM.

  6. #6
    Registered User
    Join Date
    07-16-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    8

    re: Do Until Loop

    This is great thank you.

    However, this is taking the first number and the last number and interpolating. My coding would do it between each number separately.

    when you have. 1 5 5 7 2 4

    I would like to be able to interpolate between 1 and 5, 5 and 5 so on...

    is it possible to combine my coding with yours?

    Thanks.
    Themd

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Do Until Loop

    Oops -- omitted Trend:
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    07-16-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    8

    re: Do Until Loop

    Sorry,

    I got it. I was being a little bit lazy

    Thanks for all your help,

    Themd

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Do Until Loop

    You're welcome. Would you please mark the thread as Solved?

  10. #10
    Registered User
    Join Date
    07-16-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Do Until Loop

    Thanks. I'll do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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