Filtering number of months through Input box

[vinmam123VBA]

Hi All,

Can you please help me with below requirement:

I have column where I have months from Jan to Dec.

I would like to filter for the months. Some time only for 1 month and some time more than 1 month upto 6 months

Can you please help me with code where I should enter the number of months to be filtered and then I should be able to enter months name and filter the column accordingly

For example:

If I want to filter for Jan, Jun and Sep I should be able to enter Jan, Jun and Sep in input box to filter for these three months

If I want to filter for Two months(Jun and Oct) I should be able to enter in the input box and filter column for Jun and Oct.

Regards,
Vin

 

[Dan5977]

Would it not be easier to format as a table and you can then simply filter by unticking the months you don't want?

 

[vinmam123VBA]

Would it not be easier to format as a table and you can then simply filter by unticking the months you don't want?

Thanks for the response. I am looking for code to include in one of my project. I believe Table will not help