+ Reply to Thread
Results 1 to 3 of 3

Need a drop down list to populate multiple cells with specific data

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    Indiana
    MS-Off Ver
    Excel 2013
    Posts
    1

    Need a drop down list to populate multiple cells with specific data

    I am trying to put together a spreadsheet that allows someone to choose an item from a list, which I know how to use validation to do that. I do not know how to make other cells populate with other specific information to each item in the list once the item is chosen from the original drop down list. Can anyone help me out?Quote sample.xlsx

  2. #2
    Registered User
    Join Date
    03-31-2014
    Location
    dubai
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Need a drop down list to populate multiple cells with specific data

    Quote sample-smb.xlsx

    I've converted data on DATA worksheet into Table and modified the range named "ITEM" so that if you need to add any more items your Dropdown list should update automatically.

    Hope this help.
    Last edited by smb_146; 04-08-2014 at 01:18 PM. Reason: wrong attachment

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    Indiana
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Need a drop down list to populate multiple cells with specific data

    That is exactly what I wanted to be able to do. Thanks. In order for me to make this work on other aspects/parts of my spreadsheet would I just have to change my Lists to Tables and then it would auto populate once I turn my first column into a drop down using the validation?

  4. #4
    Registered User
    Join Date
    03-31-2014
    Location
    dubai
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Need a drop down list to populate multiple cells with specific data

    Quote sample-smbRevised.xlsx

    Use this one instead of last uploaded file.

    No my dear it don't work that way.

    But you can use the basic idea to resolve any other similar issues.

    if you don't have the idea how to do this just upload a sample file.

+ 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. Drop down list to populate cells
    By rgholmes08 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2014, 01:53 PM
  2. Populate data when select a specific manager from a drop down list
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2013, 12:48 PM
  3. [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
  4. [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
  5. 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

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