1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

Excel VBA - populating columns based on dropdown lists?

Discussion in 'BBS Hangout' started by thelasik, Mar 10, 2010.

  1. thelasik

    thelasik Contributing Member

    Joined:
    May 9, 2005
    Messages:
    3,347
    Likes Received:
    72
    Suppose I have a worksheet with biodata on 4 Rockets players.

    Names: B1:E1
    Biodata: A1:A10

    Now I want to compare two players side by side at the bottom of my worksheet. I've created two dropdown lists (placed side by side) with the player names.

    How do I populate the cells directly below the dropdown list with the data corresponding to the selected player?
     

Share This Page