+ Reply to Thread
Results 1 to 2 of 2

Filtering based on values in 3 dependent drop down lists

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    85999885
    MS-Off Ver
    Excel 2003
    Posts
    2

    Filtering based on values in 3 dependent drop down lists

    Ok, so here is my problem.

    I have a dynamic dropdown list in B3. The dynamic dropdown list in B4 is a result of my choice in B3, and my dynamic dropdown list B5 is a result of my choice in B4.
    When changing a value in B3 the dropdown lists B4 and B5 will be reset. This is done by this VBA Script in my worksheet.

    Please Login or Register  to view this content.
    So to my problem.
    Under this dropdown lists I have allot of data in range A9:X200
    I want to filter this list by my choice in those 3 drop down lists. Information in B3 should filter from Column G11 and down, B4 should filter H11 and down and B5 should filter I11 and down. Could anyone help me on a solution that work with the existing script in the same sheet.


    Best regards
    fmatre

  2. #2
    Registered User
    Join Date
    02-04-2014
    Location
    85999885
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Filtering based on values in 3 dependent drop down lists

    Any help please.

+ 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. VBA Form -- Display Values based on dependent lists
    By zaveed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2013, 11:46 AM
  2. [SOLVED] Return value based on 2 dependent drop down lists
    By arsene2conde in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 10-14-2013, 09:44 AM
  3. [SOLVED] Dependent drop down lists based on dynamic data range
    By strud in forum Excel General
    Replies: 15
    Last Post: 04-19-2013, 08:08 AM
  4. Dependent Lists - Limit selections based on used values
    By jonmadjon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 09:06 AM
  5. IF THEN ELSE based on Three Dependent Drop Down Lists (VBA)
    By vtsoldier2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2012, 09:56 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