Filter multiple tables on different sheets

csotstot

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

Forum statistics

Threads
1,085,870
Messages
5,386,479
Members
402,000
Latest member
CROSBIE3103

Some videos you may like

This Week's Hot Topics

Top