Automatically hide and unhide rows based on selected month

Hi everyone!

I have a workbook with different sheets.

For overview:
Sheet 1 (Entry) = The data where the user inputs the information.
Sheet 2 (Summary) = If the user click the post entry, then the summary of the details will be added in this sheet.
Sheet 3 (DetailedSales) = This is where the breakdown of the summary goes.

I coded the recording part. My problem now is when the user select month, the table will adjust and automatically hide the rows of those are not belong to the month selected.

Please see the attached file.

In sheet 2 (Summary), cell b5, when the user select the period for december, only transaction belong to december will appear and the other will hide. In case no month selected then the table will show everything. The approach is same with sheet 3 (DetailedSales).

Thank you guys in advance!

HI Greggy99!

Thanks a lot! sorry if i replied so so late. This say, it's ok to be late than never.

Thanks!