This should be a real easy one but it's so frustrating.
I have coded all columns and all are working...except Column M. It will not filter down the years for some reason?
This is so maddening to have it all work and then this issue, I've triple checked everything, what are your thoughts? (My only assumption is with the autofilter number at 13 is causing issues?) Also is there way to make the boxes look cleaner, hard to shape to fit.
Private Sub TextBox6_Change()
Dim filterInput As Range
Dim filterRange As Range
Set filterInput = Range("M2")
Set filterRange = Range("M4:M208")
filterRange.AutoFilter Field:=13, Criteria1:="*" & filterInput & "*", _
VisibleDropDown:=False
End Sub