+ Reply to Thread
Results 1 to 5 of 5

how to create a drop down list that will populate multiple cells after selected

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    2

    how to create a drop down list that will populate multiple cells after selected

    I have a vehicle auction 4 times a year. I need to create an excel sheet that has a drop down list for the vehicles and the buyers. This will be used to auto populate the data from both the buyer and vehicle information into a printable bill of sale. The buyers will be in a drop down list as their bidder number 105,110,115,120 etc... The vehicles will be in a drop down list as the auction number 1,2,3,4 etc...
    I need to be able to select the vehicle and have it add yr, make, model, color & VIN. Then select the bidder # and have it enter the name, address, phone etc...

    I can create a drop down list but cannot make it populate the extra data into the other cells.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: how to create a drop down list that will populate multiple cells after selected

    Assuming you have a list/table of lots (and associated data) and a list/table of bidders (and associated data) you could use the key fields from those tables for the drop down Data Validation lists and VLOOKUP to return the associated data.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: how to create a drop down list that will populate multiple cells after selected

    my work in progress is attached. any help?
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: how to create a drop down list that will populate multiple cells after selected

    c15: =VLOOKUP($J$15,'BIDDER LIST'!$A$2:$G$6,ROW()-13,FALSE) and drag down

    C26: =VLOOKUP($J$26,'VEHICLE LIST'!$A$2:$F$40,ROW()-24,FALSE) and drag down


    Regards, TMS

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: how to create a drop down list that will populate multiple cells after selected

    Using your named ranges:

    C15: =VLOOKUP($J$15,BIDDERLOOKUP,ROW()-13,FALSE)

    C26: =VLOOKUP($J$26,VEHICLELOOKUP,ROW()-24,FALSE)


    Regards, TMS

+ 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