+ Reply to Thread
Results 1 to 7 of 7

combo box, data filter

Hybrid View

  1. #1
    Registered User
    Join Date
    08-30-2014
    Location
    london
    MS-Off Ver
    2007
    Posts
    15

    combo box, data filter

    Hi,
    I would like to create a data filter (kind of combo box I think).

    I want to have this data filter in cell D1 to show unique values (no duplicates) of what is in cell B2:B50000. Besides if I select a value in the filter, I would like to see all the rows associated with that value.

    Basically it works exactly as an excel data filter, but it's located in D1 instead of B1.

    Example

    B2= james
    B3=linda
    B4=charles
    B5=james

    in D1 I would like to choose between james, linda, charles (no duplicates)
    If I select james, the spreadsheet shows only rows 2 and 5

    Is it possible?

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: combo box, data filter

    We need a sample of your data to prepare the macro and the filter with right range, can you send it
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    08-30-2014
    Location
    london
    MS-Off Ver
    2007
    Posts
    15

    Re: combo box, data filter

    Thanks PCI, it works!

    Is it possible to shift the header (B1) and the names to B4 with the data validation still in D1?
    I.e.

    B4=header
    B5=james
    B6=linda
    B7=charles
    etc.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: combo box, data filter

    See attached
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: combo box, data filter

    See attach an example with filter only for column "B".
    The list for D1 is updated when accessing to sheet1
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-30-2014
    Location
    london
    MS-Off Ver
    2007
    Posts
    15

    Re: combo box, data filter

    thanks, it's perfect!

  7. #7
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: combo box, data filter

    Good news for a nice night

+ 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. combo box to filter data in excel
    By help2 in forum Excel General
    Replies: 0
    Last Post: 03-18-2013, 07:43 PM
  2. [SOLVED] Filter data by using dependent combo boxes
    By stewfeed in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-28-2013, 01:13 AM
  3. Filter Data with combo boxes
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 01:51 PM
  4. Create a combo box to filter & display data
    By Bandicoot in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2012, 11:57 AM
  5. Filter data using Combo Boxes
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2007, 04:16 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