Question related to Autofilter using min and max value selection

Excel 

You may try something like below. The following code will autofilter the column G as in the first line the constant variable called ColumnToFilter is set to 7. Change it as per your requirement.

Const columnToFilter As Long = 7    'This Will filter Column G (Units), change it as required

Public Sub AutoFilter()
Dim wsData      As Worksheet
Dim userMin     As Long
Dim userMax     As Long

Application.ScreenUpdating = False

Set wsData = ThisWorkbook.Worksheets("AutoFilter")

userMin = Application.InputBox("Input the Min Criteria.", "Min Criteria!", Type:=1)

If userMin = 0 Then
    MsgBox "You didn't input the Min Criteria. Please try again...", vbExclamation
    Exit Sub
End If

userMax = Application.InputBox("Input the Max Criteria.", "Max Criteria!", Type:=1)

If userMax = 0 Then
    MsgBox "You didn't input the Max Criteria. Please try again...", vbExclamation
    Exit Sub
End If

If wsData.FilterMode Then wsData.ShowAllData

With wsData.Range("A1").CurrentRegion
    .AutoFilter Field:=columnToFilter, Criteria1:=">=" & userMin, Operator:=xlAnd, Criteria2:="<=" & userMax
End With

Application.ScreenUpdating = True
End Sub

You may click the button called "Filter Data" on the AutoFilter Sheet to run the code.