+ Reply to Thread
Results 1 to 8 of 8

Populate multiple cells using corresponding drop down list

  1. #1
    Registered User
    Join Date
    07-14-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    3

    Populate multiple cells using corresponding drop down list

    I am trying to create a large drop down list (at least 30 items) I would then like the select item to populate corresponding information (about 13 items long). All I can find are small drop down list with about 8 cells and no way to expand this.

    I am ok with excel so if anyone has a video or step by step directions that would be helpful.

    Thanks
    A

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Populate multiple cells using corresponding drop down list

    Hello, aer2504.
    Welcome to the Forum.

    It looks like you are not familiar with forum rules, so I would suggest that you do that at your earliest convenience.

    As for your issue, please attach a sample workbook with ficticious data, and showing desired results manually.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,409

    Re: Populate multiple cells using corresponding drop down list

    Estevaoba - which forum rules are you referring to, please? I see no issue with Aer2504's opening post, its title or the nature of the request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Populate multiple cells using corresponding drop down list

    Hello, AliGW! Thank you for your note!

    I didn't mean he was breaking any rules.
    I just refer to the importance of attaching a sample spreadsheet, so that his request is easily looked into.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,409

    Re: Populate multiple cells using corresponding drop down list

    I just refer to the importance of attaching a sample spreadsheet, so that his request is easily looked into.
    Thank you for the clarification. There is nothing in the rules that insists on the provision of a workbook, although seeing one often helps.

  6. #6
    Registered User
    Join Date
    07-14-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    3

    Re: Populate multiple cells using corresponding drop down list

    Attached is an example, I would like all of the companies to appear in a drop list, once a company is selected I would like the data below it to show up when that particular company is selected.
    Attached Files Attached Files

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,409

    Re: Populate multiple cells using corresponding drop down list

    Please attach a new version of the workbook with a manual mock-up of what you are trying to achieve.

  8. #8
    Registered User
    Join Date
    07-14-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    3

    Re: Populate multiple cells using corresponding drop down list

    Thanks for the help! See sheet 2 for mock up.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Drop Down List to populate multiple values in multiple cells
    By Sgilmore in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2017, 11:17 PM
  2. Drop Down List to populate multiple values in multiple cells
    By Sgilmore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2017, 11:39 PM
  3. Need a drop down list to populate multiple cells with specific data
    By tbo812 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 02:08 PM
  4. Drop down list to populate cells
    By rgholmes08 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2014, 01:53 PM
  5. [SOLVED] Using a drop down list to populate cells underneath the drop down.
    By jfgay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2013, 04:07 PM
  6. [SOLVED] From drop down list selection populate multiple Cells
    By logcabin123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2012, 12:43 PM
  7. how to create a drop down list that will populate multiple cells after selected
    By aaronriggle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 06:59 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1