Hello, I need a macro that sums the totals per invoice line items in columns H and also repeat in column H to match the total of the invoice in column F per unique coding (service/loc) under column E. Attached example of original file with notes and second tab showing how I need the data to show after I run the macro. Thank you in advance

Attached Files

MSSL Import Sample.xlsx (20.2 KB, 7 views)

In the attached, no macro, just a Power Query query at cell A17 of the sheet Data After Running Macro which, if the data in the table on sheet Original Batch 1783 should be changed, needs refreshing (like a pivot table) by right-clicking somewhere in the result table and choosing Refresh.

Attached Files

msOfficeForums52451MSSL Import Sample.xlsx (32.3 KB, 3 views)