+ Reply to Thread
Results 1 to 8 of 8

[urgent] request for drop list function

  1. #1
    Registered User
    Join Date
    01-29-2012
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2013
    Posts
    5

    Question [urgent] request for drop list function

    Hi,

    I would like to request support form expert out there regarding the drop list function.

    Actually i did google around and found some related site about what i'm going to do with this drop list but still can't solve my problem.

    i have a list of model, part number and password on sheet 1 and on the other sheet i would like to create sort of searching list for end user easy to find the part number.

    for the searching method, i would like to create drop list on first cell then on the next cell will display all content related with item that i select on the first cell and so on.

    Please refer to my attached document and i explained everything inside it.

    Hope to get good respond from sifu out there and thank you in advance for your support.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: [urgent] request for drop list function

    Hi ikhtair,

    You need to look for "Cascading Dropdown" in Excel. See one link at:
    http://chandoo.org/wp/2014/02/13/dyn...ns-that-reset/ or
    or a video at:
    https://www.youtube.com/watch?v=rLRrYPsxGa4
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: [urgent] request for drop list function

    I think you are going to have a hard time with this because you have multiple "models" that have common selections for "lamp" but the subsequent lamp selections will have different "part names".

    I have a solution that I use for all cascading data validation I build, but it can't have a common "child name" for multiple "parents"

    You'd need your lamp name to be something more like 6D4-H/L and 6D3-H/L. This would make it unique for subsequent data validation lookups.

    I also recommend that you maintain your data in a more standard tabular database/table. Merged cells are not friendly to excel. My solution relies on this.

    I have included my proposed solution in case this is feasible for you. Let me know if you have any questions. Please note that the original concept for this kind of infinite level cascading data validation is the brainchild of Jerry Beaucaire (I think he is on mr.excel) and I have been using it myself and tweaking it for my own purposes ever since he shared it with me. Credit goes to him.

    Dynamic Drop Downs - infinite - Explained.xlsm

  4. #4
    Registered User
    Join Date
    01-29-2012
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2013
    Posts
    5

    Thumbs up Re: [urgent] request for drop list function

    Hi Mick,

    Thank you so much for your prompt feedback.
    Your solution there is exactly as what i'm trying to do.

    Thank you again.

    i will look into it and will modify some area to complete my task.

    Again, thank you so much for your support.

  5. #5
    Registered User
    Join Date
    04-30-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: [urgent] request for drop list function

    Will you be able to accommodate lamp names that incorporate the model in it in order to use this solution? I think you may have noticed that I built in a formula into the database that will do that automatically... it will likely be more of a question as to whether your users can get used to this new convention and understand it when they make their selections in the drop down.

    When you have time, go look at the defined names and the formulas that are in the data validation fields themselves... if you study the formulas you will learn more about how all of this is accomplished. Familiarize yourself especially with the offset, index, and match functions.

  6. #6
    Registered User
    Join Date
    01-29-2012
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: [urgent] request for drop list function

    Thank you Marvin for your prompt reply.
    highly appreciated.

    I will go through those link as my reference.

  7. #7
    Registered User
    Join Date
    01-29-2012
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: [urgent] request for drop list function

    Thank you Marvin for your prompt reply.
    highly appreciated.

    I will go through those link as my reference.

  8. #8
    Registered User
    Join Date
    04-30-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: [urgent] request for drop list function

    Also, don't forget to mark this thread as solved and kindly add reputation if you're so inclined

+ 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
    By sourabhv in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-08-2015, 05:22 PM
  2. Drop down list:URGENT
    By Doongchen in forum Excel General
    Replies: 5
    Last Post: 03-25-2015, 04:16 AM
  3. urgent - Drop down list if another cell has a value
    By ld2x07 in forum Excel General
    Replies: 4
    Last Post: 10-23-2014, 10:01 AM
  4. Drop Down List Box HELP URGENT PLEASE!
    By lucasprss in forum Excel General
    Replies: 12
    Last Post: 08-03-2012, 11:32 AM
  5. Request of Password on different selections of Drop down list
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-01-2011, 05:35 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