How to Hide Columns based on Two Drop Down Menus

Hi,

I have a spreadsheet which I would like to hide columns based on two sets of criteria contained in drop down menus.

I have two drop down menus, one has month (Jan-Dec) in cell A2 and one has year (12, 13, 14) in cell B2.

The months run in columns D4 to BV4 with a space column in between each month e.g. column D = Jan-12, column E = splitter, column F = Feb-12.

I would like users to be able to filter to show only a specific month and year based on choices made in the two drop down menus.

I have attempted to find an answer in forums but as I am new to VBA I am struggling and I am not sure if it works using drop down menus? Any help would be greatly appreciated!

Thank you!

This can be done using custom scroll (spin button) or using lookup and match functions... would suggest you to upload the sample file with dummy data. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

It would be good if you attach a sample workbook.