I'm looking to create some subtotals via VBA at the end of a current routine. Basically I need a couple of Sum if formulas at the end of two columns, then a summation of those two numbers, and then corresponding labels in the first column. The number of rows may change each day but i need the subtotals a two cells below the last record in column N and column O. I'm sure I've made this sound more complicated than necessary, but the attached shows what I am looking for. The final tab has the desired results highlighted in yellow in row 76 through 79 in this instance. I'd like the summation line to be there as well. The results in reality should not be highlighted. Thanks for your time!
I have sent 10% to Ozgrid.