+ Reply to Thread
Results 1 to 4 of 4

Create a Dynamic Dependent drop-down list with unique value

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Create a Dynamic Dependent drop-down list with unique value

    Hi,

    I facing an issue to create a Dynamic Dependent drop-down list with unique value.

    I have a data table with 3 columns, Country, City, and Process. This table is dynamic ie we can keep on adding new data below.
    In another section, the user has another input table where they can select the Country name from a drop-down (unique list), based upon the Country name selection, in the next column the user can select the City name (unique list) based upon cities listed in the Data table against that country. And in the third column based upon the City list, the user can select the Process available in that City. The input data set is row-wise.

    I am attaching a sample Excel file with the Data table and input section.

    It will be great if anyone can help me to crack this.

    Regards,
    Pranay
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,279

    Re: Create a Dynamic Dependent drop-down list with unique value

    In a simple way go with Pivot table.
    Attach file.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Create a Dynamic Dependent drop-down list with unique value

    solution based formula but its better to add small VBA code for recalculate sheet after cell selection because cell function should be recalculated for get active row.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by BMV; 03-14-2020 at 02:37 AM.

  4. #4
    Registered User
    Join Date
    02-05-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Create a Dynamic Dependent drop-down list with unique value

    Thanks this is quite helpful.

+ 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. Dynamic Drop Down List in Dependent Comboboxes
    By vikrampnz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2019, 03:55 PM
  2. [SOLVED] dynamic and dependent drop down list with unique values
    By Villalobos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2019, 03:50 PM
  3. 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
  4. Dynamic dependent drop-down list with cascading queries?
    By amieamieamie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2013, 09:44 AM
  5. Create dynamic dependent drop down menus
    By benji912 in forum Excel General
    Replies: 5
    Last Post: 03-11-2013, 08:19 PM
  6. Dependent list using only unique values in drop down
    By jwaldridge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2011, 05:56 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