Need macro to allow user to select month

[dwalton5]

I need a marco that will allow the user to select a month and then use that month to filter the data. For example,
1) If the user selects Jan then filter on column D
2) If the user selects Feb then filter on column E
3) If the user selects Mar then filter on column F
...
12) If user selects Dec then filter on column O

Thanks
Don

[Leith Ross]

Hello dwalton5,

Where is the user making these month selections from?

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[snb]

Run this macro:

Please Login or Register  to view this content.

Click in cell B2