VBA - Autofilter with Input Box

Hi All,

Hope you can help, i know this can be done but i have seen some conflicting codes around and wasnt sure what is the best way.

Basically i need to run a report based on monthly data ie accounts by x on x month

This is part of a larger macro which is already working, but someone wanted an addition to filter out by month.

I have attached a dummy sheet

ideally the macro would run and then a message box would come up asking for which month you would like to evaluate (ie Jan, Feb, Mar etc) once the user enters the month it would continue with the rest of the macro

Thanks in advance

Euan Dummy.xlsx

Hi alter

Try the attached.