Set all filters in Workbook to exclude current month

Hi

Looking for some help, I have a workbook with several tables across several worksheets that I want to be able to set all tables to exclude the current months data. I can obviously manually go through each worksheet but is tiresome as I have to regularly switch between 'to date' data and 'to last month' data

I have a 'remove all filters' vba as below, but cannot work out how to modify to suit. Any help would be appreciated, thank you.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the 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 Rule #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

(Note: this change is not optional. As you are new I have done it for you today.)

Is all the data in Tables?
What column has the Date or Month?
What format is the date or month column?

Examples would help.

You will want to specify the date format (e.g. dd/mm/yyyy) as your helper is Stateside, where m/d/yyyy is the norm.

This should filter serial dates in column Q regardless of the date format as long as they are serial dates.

Please Login or Register  to view this content.