|
|
|
|
#1
05-06-2024, 10:38 AM
|
|||
|
|||
Macro to summarize data
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
|
|
#2
05-24-2024, 02:24 AM
|
||||
|
||||
|
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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Summary task does not summarize % complete
|
advillanuevag | Project | 2 | 06-12-2021 06:22 PM |
|
Summarize keyword into word document
|
simba24d | Word | 3 | 06-10-2016 02:28 PM |
| a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: | udhaya | Excel Programming | 1 | 11-12-2015 10:12 AM |
|
Summarize durations by top level task
|
tcdoha | Project | 1 | 01-10-2013 11:24 AM |
|
Consolidating data using Macro
|
mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
Windows 10 
Office 2021
Hybrid Mode