+ 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
    636

    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
    636

    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)

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