JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Macro to summarize total line items per invoice
Hello, I need a macro that summs 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
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
MSSL Import Sample.xlsx A B C D E F G H I J K L M N O P Q 1 Batch 202312 H 50,043.11 Notes: 2 Invoice IN 819436 KLSSTE 12/12/2023 29,847.35 819436 30 1/11/2024 1100 CP-COR Correct Service/Loc to TR-SCF 3 Transaction 4050 TR-NAP 1 884.06 884.06 Summarize the total of each Service /Loc to match the invoice total 4 Transaction 4050 HN-NAP 1 662.49 662.49 One line TR-SCF total 12785.61 5 Transaction 4050 TR-NAP 1 852.02 852.02 One line HN-NAP Total 17061.74 6 Transaction 4050 HN-NAP 1 638.48 638.48 7 Transaction 4050 TR-NAP 1 869.22 869.22 8 Transaction 4050 HN-NAP 1 651.37 651.37 9 Transaction 4050 TR-NAP 1 888.81 888.81 10 Transaction 4050 HN-NAP 1 666.05 666.05 11 Transaction 4050 TR-NAP 1 892.64 892.64 12 Transaction 4050 HN-NAP 1 668.92 668.92 13 Transaction 4050 TR-NAP 1 887.5 887.5 14 Transaction 4050 HN-NAP 1 665.07 665.07 15 Transaction 4050 TR-NAP 1 840.85 840.85 16 Transaction 4050 HN-NAP 1 630.11 630.11 17 Transaction 4050 TR-NAP 1 787.11 787.11 18 Transaction 4050 HN-NAP 1 589.84 589.84 19 Transaction 4050 TR-NAP 1 827.85 827.85 20 Transaction 4050 HN-NAP 1 620.37 620.37 21 Transaction 4050 HN-NAP 1 644.79 644.79 22 Transaction 4050 TR-NAP 1 860.44 860.44 23 Transaction 4050 HN-NAP 1 660.13 660.13 24 Transaction 4050 TR-NAP 1 880.91 880.91 25 Transaction 4050 HN-NAP 1 649.94 649.94 26 Transaction 4050 TR-NAP 1 867.31 867.31 27 Transaction 4050 TR-NAP 1 819.59 819.59 28 Transaction 4050 HN-NAP 1 614.18 614.18 29 Transaction 4050 HN-NAP 1 627.45 627.45 30 Transaction 4050 TR-NAP 1 837.3 837.3 31 Transaction 4050 HN-NAP 1 600.78 600.78 32 Transaction 4050 TR-NAP 1 801.71 801.71 33 Transaction 4050 HN-NAP 1 654.18 654.18 34 Transaction 4050 TR-NAP 1 872.97 872.97 35 Transaction 4050 TR-NAP 1 864.03 864.03 36 Transaction 4050 HN-NAP 1 647.48 647.48 37 Transaction 4050 HN-NAP 1 659.56 659.56 38 Transaction 4050 TR-NAP 1 880.15 880.15 39 Transaction 4050 HN-NAP 1 620.57 620.57 40 Transaction 4050 TR-NAP 1 828.12 828.12 41 Transaction 4050 TR-NAP 1 819.15 819.15 42 Transaction 4050 HN-NAP 1 613.85 613.85 43 Invoice IN 819437 KLSSTE 12/12/2023 18,016.99 819437 30 1/11/2024 1100 CP-COR 44 Transaction 4050 TR-NAP 1 866.27 866.27 45 Transaction 4050 HN-NAP 1 649.16 649.16 46 Transaction 4050 TR-NAP 1 848.43 848.43 47 Transaction 4050 HN-NAP 1 635.79 635.79 48 Transaction 4050 TR-NAP 1 829.12 829.12 49 Transaction 4050 HN-NAP 1 621.32 621.32 50 Transaction 4050 HN-NAP 1 634.3 634.3 51 Transaction 4050 TR-NAP 1 846.44 846.44 52 Transaction 4050 TR-NAP 1 839.86 839.86 53 Transaction 4050 HN-NAP 1 629.37 629.37 54 Transaction 4050 TR-NAP 1 878.36 878.36 55 Transaction 4050 HN-NAP 1 658.22 658.22 56 Transaction 4050 HN-NAP 1 667.19 667.19 57 Transaction 4050 TR-NAP 1 890.33 890.33 58 Transaction 4050 TR-NAP 1 883.47 883.47 59 Transaction 4050 HN-NAP 1 662.05 662.05 60 Transaction 4050 HN-NAP 1 636.57 636.57 61 Transaction 4050 TR-NAP 1 849.47 849.47 62 Transaction 4050 HN-NAP 1 605.83 605.83 63 Transaction 4050 TR-NAP 1 808.45 808.45 64 Transaction 4050 TR-NAP 1 892.48 892.48 65 Transaction 4050 HN-NAP 1 668.8 668.8 66 Transaction 4050 HN-NAP 1 649.28 649.28 67 Transaction 4050 TR-NAP 1 866.43 866.43 68 Invoice IN 819438 KLSSTE 12/12/2023 5,683.37 819438 30 1/11/2024 1100 CP-COR 69 Transaction 4050 HN-NAP 1 1272.53 1272.53 70 Transaction 4050 TR-NAP 1 778.46 778.46 71 Transaction 4050 TR-NAP 1 688.28 688.28 72 Transaction 4050 HN-NAP 1 1125.1 1125.1 73 Transaction 4050 HN-NAP 1 1128.59 1128.59 74 Transaction 4050 TR-NAP 1 690.41 690.41 75 Invoice IN 819457 UPDS 12/12/2023 282.73 819457 30 1/11/2024 1101 CP-COR Summarize totals not showing negatives 76 Transaction 4049 HN-PDX 1 286.03 286.03 one line total 282.73 77 Transaction 4049 HN-PDX 1 -3.3 -3.3 78 Invoice IN 819458 UPDS 12/12/2023 212.67 819458 30 1/11/2024 1101 CP-COR 79 Transaction 4049 HN-PDX 1 214.33 214.33 80 Transaction 4049 HN-PDX 1 -1.66 -1.66
Here what I would like the result to look like
MSSL Import Sample.xlsx A B C D E F G H I J K L M N O 1 Batch 202312 H 50,043.11 2 Invoice IN 819436 KLSSTE 12/12/2023 29,847.35 819436 30 1/11/2024 1100 CP-COR 3 Transaction 4050 HN-NAP 1 12785.61 12785.61 4 Transaction 4050 TR-SCF 1 17,061.74 17061.74 5 Invoice IN 819437 KLSSTE 12/12/2023 18,016.99 819437 30 1/11/2024 1100 CP-COR 6 Transaction 4050 HN-NAP 1 7717.88 7717.88 7 Transaction 4050 TR-SCF 1 10299.11 10299.11 8 Invoice IN 819438 KLSSTE 12/12/2023 5,683.37 819438 30 1/11/2024 1100 CP-COR 9 Transaction 4050 HN-NAP 1 3526.22 3526.22 10 Transaction 4050 TR-SCF 1 2157.15 2157.15 11 Invoice IN 819457 UPDS 12/12/2023 282.73 819457 30 1/11/2024 1101 CP-COR 12 Transaction 4049 HN-PDX 1 282.73 282.73 13 Invoice IN 819458 UPDS 12/12/2023 212.67 819458 30 1/11/2024 1101 CP-COR 14 Transaction 4049 HN-PDX 1 212.67 212.67
Threads
1,216,515
Messages
6,131,111
Members
449,621
Latest member
feaugcruz