VBA Filter all unique values and sum totals

[Lelewiwi]

Hello-

I have a file that changes monthly that I need to utilize vba to filter all unique values (that will change every month) in column D and add up values for each unique value from column L. Any help would be appreciated! Below is a sample of what it looks like. The dates change monthly.

 

[DanteAmor]

You can use a pivot table.
First create a table of your data and create a pivot table for that table, each month only update the pivot table.

 

[DanteAmor]

Or try this formula:

=LET(a,D2:D11,b,UNIQUE(a),‎HSTACK(b,SUMIF(a,b,L2:L11)))

 

[Lelewiwi]

Thank you @DanteAmor but I don't think that will work. The file will be a different one every month. It is not the same file name that just changes. It is a completely different file.