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.