Macro to create Summary from 2 Sheets as per Months in Col D and criteria in Col M

As a beginner starter :

PHP Code: 

Sub Demo1()
        Dim W, C@(), N%, R&, V, M%
    With Worksheets("Summary")
            W = .Range("A4", .[A4].End(xlDown)(0)).Value
            ReDim C(1 To UBound(W), 1 To 12)
        For N = 1 To 2
            With Worksheets(N).[A12].CurrentRegion
                For R = 2 To .Rows.Count
                        V = Application.Match(RTrim(.Cells(R, 13).Value), W, 0)
                    If IsNumeric(V) Then
                        M = Month(.Cells(R, 4).Value)
                        C(V, M) = C(V, M) + .Cells(R, 9).Value
                    End If
                Next
            End With
        Next
            .[B4:M4].Resize(UBound(W)).Value = C
    End With
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Hello Marc,
Thanks for the code
Works like a charm
Post marked Solved, reputation added

Regards

Thanks for the rep' ! (to all)

To Yasser : there is nothing magic as it's just about mixing Excel basics & a child level logic …

Thanks Yasser !

★ ★