+ Reply to Thread
Results 1 to 7 of 7

Dependent Drop Down List (Long Parent List)

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    8

    Dependent Drop Down List (Long Parent List)

    Hi

    Can anyone help me to create a dependent drop down list when the parent list if very long, exceeding 100 in the longrun.

    Thank you.
    Jane
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Dependent Drop Down List (Long Parent List)

    Hi Jane,

    I am unable to understand how do you want to have the dependent drop down list. As the file you have attached is very confusing. Request you to please upload the exact output you are expecting to come out.


    Cheers!!!


    Anil Dhawan
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    8

    Re: Dependent Drop Down List (Long Parent List)

    Hi

    My apologies.

    Sheet!Data comprises list of revised data.
    Sheet!Actual - Col A (I had created the dropdown list)
    Sheet!Actual - Col B (I need help to create a droplist of Name of children that are dependent on the selected parent).

    Thank you for your kind assistance.

    Jane

  4. #4
    Registered User
    Join Date
    04-21-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    8

    Re: Dependent Drop Down List (Long Parent List)

    Sorry. Forget to attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-21-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    8

    Re: Dependent Drop Down List (Long Parent List)

    Hi

    Can some expert please help me. Its been more then 10 days and Anil still can't assist.

    Regards
    Jane

  6. #6
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Dependent Drop Down List (Long Parent List)

    Hi Jane,

    Sorry for the delay actually it got skipped from me.

    Refer to the attached file. I have included the dependent list and It should work.


    Thanks,
    Anil Dhawan
    Attached Files Attached Files
    Last edited by adhawan06; 05-03-2015 at 09:26 AM. Reason: Attached the wrong file.

  7. #7
    Registered User
    Join Date
    04-21-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    8

    Re: Dependent Drop Down List (Long Parent List)

    Thank you.

+ 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. Mutiple dependent drop down list with a fallback/default list on error.
    By static in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2014, 06:48 PM
  2. Create a dependent drop down list with dynamic list
    By JSmith1504 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 09:15 AM
  3. [SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list
    By ptmald in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 07:17 PM
  4. [SOLVED] Insert drop-down list in Parent Field in a form
    By haleakala17 in forum Access Tables & Databases
    Replies: 3
    Last Post: 09-11-2012, 06:00 PM
  5. [SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)
    By Waqar Ali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-26-2012, 06:31 AM

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