+ Reply to Thread
Results 1 to 3 of 3

Dynamic Range for List

  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    41

    Dynamic Range for List

    I am looking to build a dynamic range(I think I need this). Under the assumptions tab, I have the loan listed in Column A and Months remaining in column B. As you can see I built a list for each loan(58 total). The issue now is that, I plan on having many more loans and I figured it would be smart to learn dynamic range. I have looked at it online, but I am unsure as to how I should implement it. The sheet, default database calculates the maximum number of months remaining. For example, Loan 1 only goes to 56, so cell B3 of Assumptions has the range go up to 56. I want this similar logic to apply to all the loans below. I have only done to loan 58, but would prefer to use dynamic range. Thanks for the help. If any questions, feel free to ask. Thanks again
    Attached Files Attached Files

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Dynamic Range for List

    I don't really understand how you would intend to use the dynamic range. Where would it go and to what end? The table you have on the second tab seems to work (though I don't know its function). Could you walk us through an example of how you would use this information and a dynamic range?
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.

  3. #3
    Registered User
    Join Date
    09-21-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Dynamic Range for List

    Quote Originally Posted by darkyam View Post
    I don't really understand how you would intend to use the dynamic range. Where would it go and to what end? The table you have on the second tab seems to work (though I don't know its function). Could you walk us through an example of how you would use this information and a dynamic range?
    Essentially I went to Cell B3 through B59 (sheet Assumptions) and individual did a Data validation and created a list using the sheet Default Database corresponding row.
    Example: I went to B3(assumptions tab), did data validation and created list using default database row 2 between column E to FK.

    I now realize I have to do this approximately 650 more times and was hoping for a quicker method. Let me know if that helps. I think using a dynamic range I could automate this process, but I am not sure.

+ 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