PDA

View Full Version : Formulas NameManager



GhostofDoom
12-12-2019, 06:40 AM
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