Is there a way that I can program excel so that I can filter multiple tables based on a common set of slicers. I have to keep this in a table format rather than multiple pivots as the data is updated continously by users.
Sample data attached - slicers I'm wanting to use are on sheet 2 and were generated off of the first table.
For example, as an example, I would want to filter both tables by the Area slicer and just view North
Bookmarks