NEED HELP - Fix Macro Automatically SUM upper data when entering new data

[depchai]

Hi everybody.
I have a macro, it will automatically add a row and calculate SUM all the data of upper rows when I entering new data.

But if I add or delete any value in Quantity column from any Group, the SUM row will not correct because it does not plus or minus that value (please view attached file)

PN9LBOs.png

So I want this macro will calculate exactly when I add more or delete any value.
Please help me fix this macro !!! Thank you!!!! And sorry for my bad English.

Here is my macro

Please Login or Register  to view this content.

[Arkadi]

Please Login or Register  to view this content.

that line makes it skip almost all the code because the quantity column is not column 1 at all, but column 3.

[depchai]

Please Login or Register  to view this content.

that line makes it skip almost all the code because the quantity column is not column 1 at all, but column 3.

So how can I fix this code? Can you help me?

[Arkadi]

can you explain in more detail what exactly the code is intended to do? should it be inserting a row? what is the criteria? etc

[depchai]

This code will add a new row and calculate sum automatically in that new row.
For example, look at my screenshot below

PN9LBOs.png

When I entering a new data in GROUP column (Group B, C, D...) this code will add a Green row above them and SUM the data of previous Group automatically.
That how this code work.

But my trouble is when I add more data in Quantity column, it didn't SUM that new data.
In my example, SUM of Group C must be "50" instead of "45", because I've added new ID C05.
So I want this code work more exactly, I want it will plus or minus automatically everytime I add new or remove the value on column QUANTITY.


You can download my attachment excel file on post #1 and test this code. And please help me fix this code if you can.
Thank you!!!

[jindon]

See if this is how you wanted.

Please Login or Register  to view this content.

[depchai]

See if this is how you wanted.

Please Login or Register  to view this content.

Yes, I mean that. That all I want.
Thank you so much jindon. I really appreciate that.

[jindon]

depchai,

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.