Im afraid the code didnt work

I need a total for columns "B" to the one before "MonthColumn"(variable)

And need rows 4 and 7-16 filled as shown in my macro

The amount of columns is dynamic rows are not. I tried xlToLeft and such but havent been successeful

George