+ Reply to Thread
Results 1 to 2 of 2

How to change a second drop down menu selection from the selection made in dropdown menu 1

  1. #1
    Registered User
    Join Date
    09-04-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    22

    How to change a second drop down menu selection from the selection made in dropdown menu 1

    Hi

    I am new to excel and have played around with a database of parts information looking for a combination of values made in three drop down menu's.... This works and did what i required.....but now i need to up the game and change it slightly to work with other variables... This now goes beyond my current knowledge level...

    I would like to choose a item in my first drop down menu that generates the contents of the second drop-down menu.. After making the second selection i need to generate the third drop down menu..... After this i need three pieces of information to be displayed in three separate columns... If someone can point me in the right direction, then perhaps i can go one stage further, and make the first drop down selection also change the title of the second drop down menu and again for the third!!...

    Anyway, so far i have used the INDEX - MATCH functions to search three criteria and display one cell of information....

    Thanks for any information or guidance.

  2. #2
    Registered User
    Join Date
    09-04-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: How to change a second drop down menu selection from the selection made in dropdown me

    Anybody have the time to help?



    Here is the file.. I just need to know how to change the second drop down menu named position, with a limited output dependent of the selection made in the first dropdown menu.. example if a AMCU was selected there would be position 1-3, if it was an EADB, it would be 1-7. and then the info in columns F,G and H would be displayed if the required fields..
    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)

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