Autofilter popup

  • I have a need. The same filtering methods are done monthly on roughly 15k rows of data. Nothing changes, filtering-wise, other than the date. The date filter is complex so-to-speak, It is broken up by Year/Month/Day/Time.

    What I would like is that when the macro runs and it comes to field:=12 (Column L) a popup occurs which contains the exact same options as what is present when done manually. I will include code below. However, if this becomes moreso an act of god to achieve, I could be happy if the MACRO selected all entries within the year/month I am within when running the MACRO. I have many MACROS that require this ability, however, I will include a simple one.

    Here is the screen shot of the filter, in this example, I'd want everything selected in December:

  • I've tidied up your existing code.

    Can you attach a small example of your file.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!