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