Results 1 to 3 of 3

Thread: Building a drop down spreadsheet in excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Building a drop down spreadsheet in excel

    Hey guys.

    My excel skills are so poor and I am getting so stressed that I hope someone could help me here. Its so simple yet i cant do it.

    I will try and explain it to the best I can.

    I want to create an Excel sheet with dropdowns.

    So for example I would like to add data into these dropdowns...

    For example. dropdowns-

    Type of animal; cats, dogs, rabbits

    Age; 0,1,2,3,4,5 etc

    Weight; under 2kg, over 2kg

    Color; black, white, other


    I think you understand. But what I want it to do is once I have picked all my drop downs I can add data into that dropdown.

    So the next time I click that exact combination of dropdowns it brings up data i have added for that.

    I would like to be able to add as many dropdowns as possible if needed.


    To someone with experience this probably very very simple.

    I have bought a couple of excel learning books and after 15 months I still cant grasp any coding aspects of it.

    Thank you in advance

    Scott

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,929
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Building a drop down spreadsheet in excel

    Here is a link on cascading/dependent combo boxes

    Cascading Combo Boxes in Excel | The Office Corner
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


  3. #3
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Building a drop down spreadsheet in excel

    Hi Scott,

    I see only two ways to have variable dropdown lists:

    The first and most complicated is to use macro's. That is to be used only if the names to be add can com from everywhere. Note that my way to set up such macro's would be to send copy-paste the added names in the tables of the second method or userforms depending on the cases.

    The second method is based on "table". I usually build a sheet called "tables" where I have all my tables. The sheet is hidden and protected if needed. On that sheet I would have a 1 column Table for animals.

    -Title a1: Type of animal. A2 cats a3 dogs a4 rabits. I would then select a1 to a4, click insert menu and table. Select my table has headers.
    -then select a2-a4, click formulas sheet and define name and call it Listanimal. Note that your name will refer to =Table1[Type of animal] automatically if you have not named the table differently.

    -Now if you build a dropdown menu referring to =Listanimal, you will have the 3 animals. If you put another animal in a5, the table will extend and it ill be in your list.


    Voilą! Hope it helps
    Last edited by Kamolga; Jan 24th, 2016 at 02:26 PM.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •