Hello,
How can i use this to search for more 2 or more Criteria?
for example
i like to search with those 2 strings: a empty space and Sending
searching with 1 string works likes a charm, now i like to search on more then 1 Criteria
DataSH.Range("T9").Value = txtSearch.Text
DataSH.Range("B8").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=DataSH.Range("T8:T9") _
, CopyToRange:=DataSH.Range("V8:AM8")
ListBox1.RowSource = Sheet3.Range("outdata").Address(external:=True)
this is the formula in name manager we use
'ouddata:
=OFFSET(sheetlist!$V$9;0;0;COUNTA(sheetlist!$V$9:sheetlist!$V$9978);18)
'search Criteria
=sheetlist!$T$8:$T$9