Filter by searching for AutoFilter

When using AutoFilter, users type text or number in the search box and press OK button. Excel will apply the filter according to searching result.
For example, if a user type "100" like the screenshot below

After clicking OK button, only those rows containing "VV100" should be visible.

Reference: https://support.office.com/en-GB/article/Use-AutoFilter-to-filter-your-data-7d87d63e-ebd0-424b-8106-e2ab61133d92?CorrelationId=9eb7e779-ae60-4336-8e1c-6e66a1532ac8