filter data based on month

hi
I search answering for my problem I would filter data based on month when I fill in cell c2 in sheet2 I try using function month or month name but I failed so I hope find the answering in this great forum
by the way I also issued this post in this forum , but nobody answers me so far
https://www.mrexcel.com/board/thread.../#post-5633105

Enter month number, 1 for Jan, 2 for Feb..etc in C2

Please Login or Register  to view this content.

I was able to meet your requirements but had to create a new file, here is code and new file

Please Login or Register  to view this content.

thanks you're both it works very well
@maniacb just I would mod your code if there is way to make me show the month based on language English I have to write pc language

@jindon your code is perfect if you can write the month by name not number

What do you mean?

It should also work when month number is entered.

@ jindon sorry i though just number 1,2
thanks very much