I have a file similar to the attached file.
Part of the file is an export file I got and I am filling last 2 columns.
I need to fill last 2 columns with 0(green) if it is not a total row(A1 Total, A2 Total etc).
And, I need to fill Total rows with the sum of that group(yellow).
I would like vba code to do this as I need to do this on a regular basis and bigger sets of data.