Filter, Link & Align & Sort Excel Tables on Seperate Worksheets using Slicers or Autofilters

Donload the Free File here:


We can all Filter multiple Pivot Tables using 1 Slicer or multiple Pivot Tables using multiple Slicers - it's easy, right? But what about Filtering, Linking and Sorting Excel Tables NOT Pivot Tables? Well here is an example of doing just that. With my Code you can Filter Excel Tables on different Sheets using Slicers or Table Filters. When you Filter any Table on a Worksheet all of the other Linked Tables will be Filtered exactly the same. You can apply Sorts to different Columns and they will also align in both Tables respectively

Features: use Table Filters or Slicers to align your Tables on different Sheets
Caveats: a Formula should be added to all Sheets to force Calculations. only 1 Table per Worksheet. Only shared Table Fields can be aligned (Filtering different Fields will break the alignment). The Sort can be Ascending/Descending and on multiple Columns, cool eh?

Excel,Tables,Multiple,Link,Filter,Slice,Sort,