Filtering Identical Tables Simultaneously

The only way I can imagine to to use VBA to copy the filters from one to the other. The code example from Help is posted in https://www.excelforum.com/excel-gen...ml#post4915942

So a couple points here.

If your Excel version in your profile is correct (2010) then there is no built in way using the filtering mechanisms themselves to filter multiple tables. In Excel 2016 (maybe 2013 too if I recall correct) you can apply slicers to tables (regular tables as well as pivot tables). A slicer is essentially a somewhat more visual filter. You can connect a slicer to multiple tables as long as they are sourced from the same exact data source. I am 100% sure a slicer works on a regular table in newer versions of Excel. I am foggy on if the linking a slicer to multiple tables only works with pivots or also works with standard tables.

EDIT: In testing it appears even in 2016 the slicer can only connect to multiple pivot tables, not multiple standard tables.

I also found that replicating the table can be done using data connections. For me it was as simple as creating another sheet, going to Data | Existing Connection, clicking the tables tab and selecting that table. In the dialog selecting table and existing sheet as the destination. It duplicates the table on the new sheet. It functions a bit like a pivot table, needing a "refresh" to show any updates made to the original table (like deleting a row or adding a row). However it did not imitate the filtering I applied to the original table.

I am however not sure I see the need for 2 identical tables with the only difference being formatting for screen and print. Excel should be able to, via the page setup, scale and break apart the printed pages to make them legible regardless of what it looks like on screen (to a degree). Hard to say though without knowing what it looks like. So as an alternative to 1 filter for 2 tables you may try approaching it by addressing the needs of print vs screen using the page setup features in Excel instead and using a single table.

As mentioned the last alternative is using VBA to apply the filtering to multiple tables. Not sure its worth the trouble though