VBA for Collapsing Rows based on date entered in column A

[DRH428]

I want to be able to enter the month in a cell at the top and collapse all rows with the date in column A that are outside the month selected.

 

[TryingToLearn]

It would be helpful if you posted the version of Excel and the OS you are using.

It seems to me it would be easier to simply use the FILTER function (CTL + SHIFT + L) and select the month you do want.