Partial input text to work in auto search filter...

LearnerExcel · #1 03-07-2018, 07:50 AM

The following code is working fine but I need to input full text of a cell to get the result. How to modify this code to search with partial input text that shows the related rows?

Code:

 
Private Sub Worksheet_Change(ByVal Target As Range)
'Updateby Extendoffice 20160606
   If Target.Address = Range("M2").Address Then
       Range("A3:M700").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("M1:M2")
   End If
End Sub

Note: For Example, Cell M300 has the data "FFCE4600" and If I input text in M2 as "FFCE" it shows all the records which contains text FFCE but when I input "4600" it shows nothing. How to resolve this problem?

ArviLaanemets · #2 03-08-2018, 01:55 AM

Wrong thread!

NoSparks · #3 03-10-2018, 04:31 PM

Use regular autofilter and wildcard character (*).

Google "Excel filter as you type" to see another approach.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-correct on existing text without input	m9rbid	Word	1	12-18-2017 01:20 PM
Filter Search Button	lonniepoet	Excel Programming	53	12-23-2015 02:27 PM
filter using wildcard doesn't work with Outlook 2007	clif9710	Outlook	0	07-15-2015 02:22 PM
How to Input Actual Overtime Work	caveman	Project	13	03-31-2015 05:24 PM
Insert input box into macro to allow user to define search term	Hoxton118	Word VBA	3	05-19-2014 02:03 AM