+ Reply to Thread
Results 1 to 11 of 11

Horizontal Filtering (Column Filtering)

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Horizontal Filtering (Column Filtering)

    Hello All,

    I have been struggling with creating a Training Matrix for our facility that will encompass every Department, Employee and training that is annually given. I have completed formatting that allows notification of the need to retrain or certify as well as set up the sheet to filter between Employee Names and Departments.
    But, a big need in the sheet is to filter between Category's, Types of Training, Schedule, and Specification which are inserted into the table Horizontally. I have searched forums for an answer to this and come up short.
    Any help on formatting Horizontally will be greatly appreciated.

    Example:
    2014-11-18 15_04_57-Microsoft Excel - Copy of Camarillo Training Matrix (3).xlsx.jpg

    I would like to Filter between the different Types of Training. If I want LOTO I want to filter to just LOTO. Same for JSA Camarillo and Others.

    I have attached a copy of the Initial Training Matrix if this will help. Copy of Camarillo Training Matrix (3).xlsx

    Thanks,

    dundraburl

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,377

    Re: Horizontal Filtering (Column Filtering)

    Hi Dundraburl,

    Welcome to the forum! We can just hide columns for the nonce BTW - There is no LOTO on the sample sheet?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Horizontal Filtering (Column Filtering)

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Re: Horizontal Filtering (Column Filtering)

    Hey stnkynts !

    This is great! Almost exactly what I need. I was just wondering if there were a way to do this with a drop down menu (like row filtering) that you could select between the categories??

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Horizontal Filtering (Column Filtering)

    A "drop down" menu can be achieved many different ways. Specify exactly how you are going to achieve this "drop down" menu

  6. #6
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Re: Horizontal Filtering (Column Filtering)

    When I say that I want a drop down I am wondering if there is a way to bring up a drop-down menu with my choices instead of a "Ctrl+F" type function. A sort of example is attached Copy of Camarillo Training Matrix (3).xlsm . I utilized the code that was given earlier to create buttons for each row I wanted to filter. But if possible I would much rather it be a drop down button or a button that creates a drop down.

    The problem is that this matrix is that it is essentially for the use of our supervisors who are a lot less computer Savy. Giving them the matrix and asking them to type in what they are looking for (especially when it is case sensitive) seems to be a loosing battle. I am just trying to make it as easy as possible for everyone that will be touching the workbook.

  7. #7
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Re: Horizontal Filtering (Column Filtering)

    Could you please see below if you have time.

    Thanks

  8. #8
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Horizontal Filtering (Column Filtering)

    In your attached workbook you are using a Form_Control ComboBox. Replace that with an ActiveX type ComboBox. Do a google search if necessary on how to populate values into the combobox.

    Assuming name (ComboBox1)
    Please Login or Register  to view this content.
    Amended Filter code
    Please Login or Register  to view this content.
    Tested and worked.

  9. #9
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Re: Horizontal Filtering (Column Filtering)

    I added the above coding to the document and now I get an error "runtime error '94' invalid use of null" and the debugger points to strBox = ws.OLEObjects ("ComboBox1").Object.Value

    I tried a few different things to fix this but nothing worked.

  10. #10
    Registered User
    Join Date
    11-18-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    7

    Re: Horizontal Filtering (Column Filtering)

    Here is a copy of the updated document. Copy of Camarillo Training Matrix (3).xlsm

  11. #11
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Horizontal Filtering (Column Filtering)

    Something was up with your combobox. I deleted it and inserted a new one and it worked just fine.

    Also you didn't have any values set to the combobox to select. On the combobox go to properties and look at ListFillRange. Google search it for further information.

+ 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] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  2. trouble filtering a list. Why isn't column filtering?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. Replies: 1
    Last Post: 07-18-2005, 11:05 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