Payroll worksheet needs a new filter

    I have added a new request if this can be done.


    I need to have a command button named 'Filter' on the 'Instructions' tab to run a macro. This macro will display a list from the column 'AB' on the 'Instructor and Location Payrate'. I would like to be able to select more than one item on this list at a time. The items select if a match is found from column 'J' on the 'Instructor Pay Data' tab, the value in column 'Z' on the same tab 'Instructor Pay Data will change the color of the font and the value will not be included on the PivotTable located in the tab named 'Instructor Summary'


    I realize this is a lot, just very curious if this can be done, and how that VBA looks. :)


    Thanks

    As you say it is a lot to ask in a free forum!


    What you want should be possible, I will do something to get you started, but for a full solution I suggest you need to post in the Hire Help Forum.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    You are lucky, today is Sunday, it is raining here, and I had nothing better to do so I did all you wanted.


    Your file attached with new codes.


    Click the "Filter by Class Type" button, a list box with all the Class Types will appear, select from that list as required (it is set to multi-select), 2 more buttons will appear, click "Apply Filter(s)" to colour the font in the 'Instructor Pay Data' sheet column Z where Column J is the selected value(s), and filter the 2 pivot tables on the 'Instructor Summary' sheet excluding the selected item(s).


    Click the "Clear Filtering" button to clear all pivot table filtering and to clear the list box and hide it plus the 2 buttons.


    Note I added a filtering field to your pivot tables, I also put a line of code in the Workbook_Open procedure that will protect the 'Instructor Pay Data' sheet and set "User Interface Only" to True, that means all codes will work for changes to that sheet without the need to unprotect then re-protect the sheet (but it remains protected for user trying to make changes manually).

    KjBox


    Your Sunday kindness is immeasurable ... !!! :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Thanks 1

    ^^

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login