+ Reply to Thread
Results 1 to 5 of 5

Using a DV List to populate a list

  1. 03-01-2011, 02:23 PM #1
    zac507
    zac507 is offline
    Registered User
    Join Date
    03-01-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy Using a DV List to populate a list

    I am creating a sheet that will pull information from another sheet based upon a drop-down list.

    There are two sheets. "Group" and "Individual"
    "Group" contains three columns, "Account", "Rep", "Type".

    When I am on the "Individual" sheet, I have a cell with a DV list of all the possible "Rep" options. When I select a "Rep" I would like that sheet to populate the other information.

    Example:
    When "Dan" is selected I want all of Dan's accounts and account types to be listed.

    I cannot figure this out. Please help. Thanks!
    Reply With QuoteRegister To Reply
  2. 03-01-2011, 02:26 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Using a DV List to populate a list

    Sounds like you want something like this

    http://www.contextures.com/xlDataVal02.html
    Combine that with VLOOKUP to populate your sheet.
    Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 03-01-2011, 02:42 PM #3
    zac507
    zac507 is offline
    Registered User
    Join Date
    03-01-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Using a DV List to populate a list

    Not quite. I attached what I am talking about. Sorry, probably should have attached first.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-01-2011, 03:22 PM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,956

    Re: Using a DV List to populate a list

    It is possible to do what you need with a bunch of complicated formulas, but given your data layout I would say that AutoFilter is a built-in feature that would meet your needs better than setting up a new worksheet that just points back to the same data on another worksheet.

    Any reason that AutoFilter doesn't fit the requirements? See attached for example.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  5. 03-01-2011, 04:48 PM #5
    scottylad2
    scottylad2 is offline
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Using a DV List to populate a list

    try this, if you got thousands of rows worth of this stuff it might be a little slow....but beautiful array formulas always are


    needs to be entered with ctrl + shift + enter

    ps you'll see from the index part of this formula i've made some new names for your lists
    Attached Files Attached Files
    Last edited by scottylad2; 03-01-2011 at 04:50 PM. Reason: edit
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1