Help Request - for Advanced Filter Macro VBA

Hello,
I would like to have data from my master sheet to another one based on multiple criteria filter.
My master sheet can be manually filled and it may have blank cells.
Two Macros developed in the VBA project:
______________________________________________________________________
Sub FilterMe()
'
' FilterMe Macro
' Advanced Filter
'
' Keyboard Shortcut: Ctrl+Shift+D

'Application.CutCopyMode = False
Sheet1.Range("durations#All").AdvancedFilter Action:=xlFilterCopy _
, CopyToRange:=Sheet58.Range("A11:du15000"), _
Unique:=False
'ActiveWindow.SmallScroll Down:=-3
End Sub
_______________________________________________________________________
Sub ClearMe()
'
' ClearMe Macro
' Clear Data
'
' Keyboard Shortcut: Ctrl+Shift+C
'
Range("A12:DU12").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWindow.SmallScroll Down:=-126
Selection.Clear
End Sub
_______________________________________________________________________

Both data list range and filtered data range are tables


The blank cells are managed by the following formula:
=(IF(DY3="","*",DY3))

The issue is that the advanced filter basically report all lines without filtering as defined per the Criteria range (selecting one or more criteria condition leaving the remaining conditions blank)

Please help!!
thanks a lot