Need Macro to get data for last 3 months, 6 months, 12 months etc

Hi,

I need macro which, on selection will show data for last 1 month, 3 months, 6 months and 12 months. It would be great if we have buttons for 1 month, 3 months, 6 months and 12 months, clicking on which it will only show data for that particular period. I also need a button which would say something like "Show All" data, clicking on which it will show all data again.

Attached is a sample sheet.

Thanks a lot in advance.

Give this a shot - the user can select the number of months to go back or enter "all" to show all the months. You can tie it to a button or hotkey if that's your preference.

Please Login or Register  to view this content.

Another:

Please Login or Register  to view this content.

Thanks cantosh and JOHN H. DAVIS. It worked.

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.