Autofilter with multiple criterias from a single cell

[Ernest_PLM]

Hi,

I have a spreadsheet that that I am trying to run a macro that does an Autofilter on a range Sheets("Criteria").Range("A1:L2").

Here is the VBA code that does the autofilter:

Sheets("Source").Range("A1:L108784").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Criteria").Range("A1:L2"), CopyToRange:=Range("A1") _
, Unique:=False
​

What i would like to do is have the value in Sheets("Criteria") Cell D2 & H2 to be able to have multiple criteria. I have tried putting "=or("text1","Text2")" in the cell as other forums have suggested but this doesn't work.

Am i able to do this and if so how?