VBA Codes: calculation Total for a new column C from column A and B (minus)

[vbanewbie68]

Hi Sir or Madam

I need your advice please, your help on this is much appreciated.

I am working on bringing data reports from the platform.

See the screenshot below: the columns are Payment Amount and Payment Provider Fee. In the VBA I need to know how to write codes to work out how to insert a new column with a heading such as Net Total. This is to calculate Column A and Column B together, the payment amount and the payment provider fee, putting the total amount into Column C as Net Total?

Please note that payment amount and payment fee can be varied up and down, for example Payment Amount can either be more than 7 rows or less. Same with the Payment Fee as well. Net Total needs to highlight rows automatically.

Thank you in advance.

Best regards

Vbanewbie68

 

[vbanewbie68]

In addition for your information. I am not sure how to use VBA Code to substract from A column to B column to give C the total amount. Hope it makes sense? Thank you.