Autofilter on 2 tables

Hi all,

First time poster so go easy on me!!

I have a worksheet which has 2 tables within it. Each table has a filter set up. My desire is for the tables to auto filter when new data is added.

My current code is:

Please Login or Register  to view this content.

The 2nd table is creatively called "Table2"

How can I add to the code to have both tables autofilter? Can I ListObjects multiple tables in some way?

Thanks in advance.

M

Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.