All Date in period filter

Does anyone know how to create an “AllDateinperiod” filter with dynamic dates.  Autofilter only allows filtering by month and quarters, I want specific date range.  I am new at VBA and need some help.

I have 5 years of data (41K rows) and want to filter for specific date ranges and show all years.

Currently I created a filter using VBA and a userform, however it only returns data for the specific date range year.  I want to expand it to bring back all data no matter the year.

By: Mike

Leave a Reply

Your email address will not be published. Required fields are marked *