Is there any way to apply a filter to multiple tables on separate sheets?
I need to have a pick list of filter values (cost centers generated by a query) that will be used to filter 5tables, each on its own worksheet in the workbook. Users will select a cost center from the pick list (the back end query selects multiple cost centers that are applicable to each specific user; they'll pick a center from the list) and the tables should filter to the selected cost center. Once the user completes viewing one cost center, they should be able to select a different cost center from the pick list to review...
I need to have a pick list of filter values (cost centers generated by a query) that will be used to filter 5tables, each on its own worksheet in the workbook. Users will select a cost center from the pick list (the back end query selects multiple cost centers that are applicable to each specific user; they'll pick a center from the list) and the tables should filter to the selected cost center. Once the user completes viewing one cost center, they should be able to select a different cost center from the pick list to review...
