Auto Filter using Cell name

Hi I want to filter data using Cell names


My Filtering data is in Sheet1 and the criterial data is in Sheet3

In Sheets("Info").Range("Device_Description_1") I have the value WAVE-274.

So I have wrote a working code to filter data using

Please Login or Register  to view this content.

but now I want to change Criteria1:= "=*WAVE-474*" and make Criteria1:= Sheets("Info").Range("Device_Description_1").Value.

As long as the cell contains "Device_Description_1" Value, it should filter but I am not getiing any data.

Any idea how to do it?

Thanks In advance,

Hi,

No it didn't work. Device_Description_1 value is only "WAVE-474" but the output of filtered data has "WAVE-274-K9-RF". So it is only part of the output, not exactly the same. That's why I used

Please Login or Register  to view this content.

before (Criteria1:="=*WAVE-274*").

So I thought if I do

Please Login or Register  to view this content.

But it doesn't work either