[VBA] Applying filter to multiple tables on same sheet

[kleinmat]

Hi all,

I have an Excel Sheet with 3 Tables on a single Tab.
Let's say that Columns B & C contain First Names and Last Names, and that the content of these columns is the same across all three tables. The only difference between these tables is the columns to their right.

What I simply can not figure out is how I can automatically apply the filter criteria chosen in the first table to all three:

So instead of setting the filter "Last Name = Myers" on all three tables manually, I would like to set it on Table1 only and then have this very same filter applied to Table1, Table2, Table3 at the same time.

I know similar questions have been asked here before and I did read the answers I could find, but given I am new to VBA, I was not able to apply these answers to my problem.
Are you kind folks willing to help?

Thank you!
Matt

 

[John_w]

I thought I'd seen a similar request before and was surprised to see that it was you back in March:

Sync AutoFilter between 2 Tables on same Worksheet

Hi, I have a workbook with a Sheet that contains 3 tables. The first 2 columns of each table hold the exact same information. I have turned those columns into proper Excel Tables, calling them Table1, Table2, Table3. I have also added an Auto-Filter to all three. Now I am trying to find a way...

www.mrexcel.com

Have you tried my code in that thread?

I've now revisited my solution in that thread and fixed the problem of the tables not synchronising and will post the updated code there.

 

[kleinmat]

Interesting, my memory must be failing me. THANK YOU! I have not seen your original reply until now, and I will continue the conversation in the other thread!