+ Reply to Thread
Results 1 to 2 of 2

Enter data, drop down 1 cell, enter more... etc...

  1. #1
    Registered User
    Join Date
    02-05-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    365
    Posts
    87

    Enter data, drop down 1 cell, enter more... etc...

    Guys quick one I hope... the google search on this keeps showing me drop down box info, so I guess my terminology isn't good...

    I've a variable set from another function, called "PTYCNT" it's value is 3 (in this instance)

    I want to ADD data (from another calculation) into cell M4, and go down by "PTYCNT" cells adding data as I go, but only by the number of cells returned by the variable (which will never start anywhere other than M4, and never go below M16).

    Hope someone can help, I could post code for this ( an example sheet maybe ) but I'm not sure it would be clear without more info than the above.
    Last edited by Darth269; 02-13-2012 at 04:43 PM.

  2. #2
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: Enter data, drop down 1 cell, enter more... etc...

    Use a For Next loop with 1 to PTYCNT as the variable. ie

    Please Login or Register  to view this content.

+ 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