+ Reply to Thread
Results 1 to 2 of 2

Filter checkboxes outside of the column header drop-downs

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Australia
    MS-Off Ver
    Office 2010
    Posts
    5

    Filter checkboxes outside of the column header drop-downs

    Hi guys

    I'm having a lot of difficulty trying to figure out if/how I can make this work. Bear with me while I explain what I'm trying to achieve:

    You know when you filter data and in the column heading, it has the drop-down arrow with the checkboxes that allow you to filter based on the contents? Like, say you have 'Brands of Car' as your heading and under that you have Mitsubishi, Toyota etc., and you can tick whether or not to display records that contain that model?

    I'm trying to get these checkboxes to appear ABOVE the table, because I know for sure my co-workers aren't even going to attempt to use this document if they have to to use filters by going into the heading.

    For example, above the table with the data I'm looking to have something like...

    Show all results: []

    Show results for: [] Mitsubishi [] Hyundai | [] 4 cylinder [] 6 cylinder | [] Two-door [] Four-door

    Brands of Car | Cylinders | Doors
    I would post the spreadsheet but the data is kind of sensitive.

    Does that make sense? Is this possible? The 'Show all results' checkbox is totally optional but would be a big bonus - really just looking for a way to display the individual checkboxes.

    Thanks for your help :D

  2. #2
    Registered User
    Join Date
    07-16-2014
    Location
    Australia
    MS-Off Ver
    Office 2010
    Posts
    5

    Re: Filter checkboxes outside of the column header drop-downs

    Anyone?

    Here's a visual aid for what I'm trying to figure out:
    visualaid.png
    So, trying to get the filter checkboxes (circled) outside of the drop-down and above (where the blank checkbox is).

+ 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] Filter one column with multiple checkboxes
    By pjohnson05 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-15-2021, 03:19 PM
  2. Pivot Table - Keep Field Captions (headers) without filter drop downs
    By Michelle Mitchell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2012, 08:18 PM
  3. [SOLVED] I want to make a packing slip with macro enabled drop downs in the Item # column.
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 10-10-2012, 10:18 AM
  4. Hide Filter Drop downs
    By sforney123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2011, 01:53 PM
  5. Multi column drop downs Alpha & Numeric
    By niffy in forum Excel General
    Replies: 1
    Last Post: 04-19-2011, 02:24 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