Filter multiple tables on different sheets

csotstot

New Member
Joined
Jun 1, 2017
Messages
20
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...
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,090,473
Messages
5,414,741
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top