+ Reply to Thread
Results 1 to 10 of 10

Update cell list based on Drop down List

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    new jersey
    MS-Off Ver
    Excel 2010
    Posts
    24

    Update cell list based on Drop down List

    How can I update a list (1-10) of items that are dependent on a data validation selection?

    I am not looking to create two drop down lists, I would like cells A1 - A10 to populate depending on my drop down selection.

    Thank you for your help!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Update cell list based on Drop down List

    A
    1
    10
    2
    3
    100


    Assuming your DD is in A1, you could use something as simple as...
    A3=$A$1*10

    If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-18-2013
    Location
    new jersey
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Update cell list based on Drop down List

    Ford,

    I am not using numbers - just words.

    for example: Depending on what is selected from the drop down: Lets say a State in the US.

    The below cells will populate with the cities in that state.(which are located in a different tab and labeled lists)

    Appreciate your help!

    Thanks!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Update cell list based on Drop down List

    Upload a sample workbook

  5. #5
    Registered User
    Join Date
    08-18-2013
    Location
    new jersey
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Update cell list based on Drop down List

    Data list example.xls

    Ford,

    Please see the attached. Thanks so much for your help !!

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Update cell list based on Drop down List

    What version(s) of Excel does this have to work in?

    The sample file is in the *.xls format but your profile says you're using Excel 2010.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Registered User
    Join Date
    08-18-2013
    Location
    new jersey
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Update cell list based on Drop down List

    I am using 2010.

    I saved the file again, please see attached.

    Thanks!
    Data list example.xlsx

  8. #8
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Update cell list based on Drop down List

    One way...

    Enter this formula in B3 and copy down as needed:

    =T(INDEX(LISTS!B$2:D$8,ROWS(B$3:B3),MATCH(B$1,LISTS!B$1:D$1,0)))

    Note that in the sample file on the Lists sheet, cells B1 and C1 have trailing space characters.

    In the dropdown list on the example sheet, Montana also has a trailing space character.

  9. #9
    Registered User
    Join Date
    08-18-2013
    Location
    new jersey
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Update cell list based on Drop down List

    Tony Thank you so much this worked perfectly!!

  10. #10
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Update cell list based on Drop down List

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ 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. Update specific sheet based on drop-down list parameters
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 07:42 AM
  2. [SOLVED] Update respective cell values in the table based on Multiple Drop Down list selections.
    By nileshpatil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2012, 09:30 AM
  3. How to update particular cell according to Drop down list selection?
    By nileshpatil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2012, 08:49 AM
  4. [SOLVED] Update respective cell value based on Multiple Drop Down list selections
    By nileshpatil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2012, 08:43 AM
  5. [SOLVED] Update values based on drop down list
    By canadiang8r in forum Excel General
    Replies: 2
    Last Post: 04-13-2012, 10:07 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