How to modify code for Auto filter based on two criteria ...

LearnerExcel · #1 02-11-2018, 07:19 AM

How to modify the following code for Auto filter to search based on two criteria ...
Like : CriteriaRange:=Range("E1:E2") & CriteriaRange:=Range("F1:F2")

Code:

 
PrivateSubWorksheet_Change(ByValTarget AsRange)
'Updateby Extendoffice 20160606
   IfTarget.Address = Range("E2").Address Then
       Range("A1:C20").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("E1:E2")
   EndIf
EndSub

Source: https://www.extendoffice.com/documen...ell-value.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.	phillipsdp	Excel	1	11-09-2016 12:53 AM
Filter Mail Merge based on a list of filter criteria	AusSteelMan	Mail Merge	2	05-09-2016 03:35 PM
Auto fill drops down using VBA code based on selection	AgilityJS	Word VBA	5	11-03-2015 07:50 PM
Forgotten Sort and Filter Criteria	rbdmg	Mail Merge	0	10-31-2011 09:14 PM
Modify vba code to print based on name in the InputBox	OTPM	Project	0	05-25-2011 02:03 AM