Macro to clear row containing Total and sum Col B and Col C

I have written code to first clear the last row where "Total" is in Col A as well as the values in the same row as "Total" in Col B & C

I cannot get this to clear the last row where total is as well the values in the same row as "Total" in Col B & C


Secondly I need to total Col B & C. My code is only totalling Col B

See code below

Please Login or Register  to view this content.

It would be appreciated if someone can kindly assist me

Thanks for the help.


Every time I run the Macro, The total values move down by 3 rows. Every time I run the macro, I need the total row to first be cleared and then the data added 3 rows after the last row containing the data


See sample data attached

The row containing Total Value moved down by 3 rows each time the macro runs

Hi Sintek

I have resolved it


See amended code below

Please Login or Register  to view this content.