+ Reply to Thread
Results 1 to 6 of 6

Dependent drop downs with filters

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Dependent drop downs with filters

    I have a sheet named "Line2" which has my data in it. In Column D, it has Area in it and in column E, it has Equipment type in it.
    On another Sheet named "Final Log", in column C i have same Area in it, but user select through drop down.
    I want when user select area from drop down in Column C, its related data(from sheet Line 2) should come in Column D(but in a drop down) and same goes for column e(Equipment ID)
    when selected by user from drop down, it should show its related data in column E(Equipment ID) in a drop down. Please Help
    Attached are snapshot and file
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Dependent drop downs with filters

    I believe that the information in the first section of the linked article will help you achieve what you want.
    https://www.ablebits.com/office-addi...n-lists-excel/
    The attached copy of the file has been partially set up with the dependent drop down for Feeding as well as the four subcategories under Feeding (Conveyor, Cylinder, Fan, Panel)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Dependent drop downs with filters

    @JeteMc Thank you so much for your kind reply and time. I will try it, if needed your kind help i will post here..Thank you once again...

  4. #4
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Dependent drop downs with filters

    I have added all the data as you did for dependent drop down for FEEDING, Can you please now apply the procedure as data is ready.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Dependent drop downs with filters

    Ah I did it..Well Thank you so much for your help, really appreciate it...

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Dependent drop downs with filters

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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 dependent on 2 previous drop downs
    By mrkawht in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-16-2018, 02:39 PM
  2. [SOLVED] Dependent Drop-Downs
    By Rustico18 in forum Excel General
    Replies: 5
    Last Post: 03-09-2017, 12:14 AM
  3. Initial default drop downs and dependent default drop downs
    By hudsone777 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2016, 07:05 PM
  4. Filters and drop downs
    By BradleyN1 in forum Excel General
    Replies: 0
    Last Post: 07-09-2014, 12:07 PM
  5. Dependent Drop-Downs
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:06 PM
  6. Dependent drop downs.
    By Mattypb in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-16-2009, 08:47 AM
  7. Drop downs & filters
    By CarlS in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-02-2009, 09:03 AM

Tags for this Thread

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