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

Please Login or Register  to view this content.

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??

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

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.

Could you please see below if you have time.

Thanks

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.

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.

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

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.