Problem in Macros Adding the dynamic chart to show orders between dates

[MdYas]

Hi Expert,

I have created dynamic names ranges to collect the data for the dates and totals. These dynamic named ranges are called “ChartDate” interface sheet "L25" and “ChartTotal” interface sheet "N25".

Criteria: ("AA7:AC8") for detail please see the attached file. Screenshot (4).png

Extract: ($L24:$N$24)

after creating dynamic names i have recorded macro name test, then advance filter i.e. sheet name orders ("Orders!$C$5:$L$1000"), sheet name interface Criteria: ("AA7:AC8") & Extract: ($L24:$N$24).

Please see the below code of adv filter

Sub AdvFilter()

Sheet2.Range("C5:L10000").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("AA7:AC8"), CopyToRange:=Range("L24:N24"), Unique:= _
False

If Range("N25") = "" Then
Range("L25") = "12/12/12"
Range("N25") = 0
End If
End Sub

getting error: The Extract range has a missing or illegal field name.

after recording macros date customer total not displaying.

Thanks in advance.

[MdYas]

Dear Experts,

When shall I expect a reply of my above subject? I hope they did not escape from experts.

[MdYas]

Dear Experts,

When shall I expect a reply of my above subject? I hope they did not escape from experts.