+ Reply to Thread
Results 1 to 2 of 2

Dropdown menu respects filter

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    7

    Dropdown menu respects filter

    Hello guys,

    I have a normal validation dropdown menu/list. (say it is based on the cells B1:B20)
    When i use a filter and the results are cell B1,B5 and B8 the dropdown menu still shows cel B1:B20
    How can i make it only show cell B1,B5 and B8? I hope somebody can help me!

    Gr.
    Blue

  2. #2
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Dropdown menu respects filter

    Possible...
    please attache sample data sheet.

    Regards,
    Suhas

+ 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. [SOLVED] How a drop down menu's list can change depending on another dropdown menu.
    By marc1980 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 04:58 PM
  2. [SOLVED] Using dropdown menu to filter table, possible?
    By Jaymes88 in forum Excel General
    Replies: 2
    Last Post: 05-10-2013, 10:11 AM
  3. [SOLVED] Excel 2007 : new drop down menu based on dropdown menu in previous cell
    By martinpols in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 02:33 AM
  4. Create Dropdown menu without using the Validation on the Data Menu
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-13-2006, 03:47 PM
  5. dropdown menu or Jump menu
    By the dude in forum Excel General
    Replies: 1
    Last Post: 03-26-2006, 02:58 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