Hi, how do i get a macro to do a sum at the end of each second column ?, so i need to sum the values in Col 2, 4,6 etc, but the macro should know when the last data in the column ends
I need the formula should skip a row after the data ends so its easy to see all the summed amounts, so for example say if the data ends in row B35, then the formula should be in B37, then D37, F37 etc
Can this be achieved?
I need the formula should skip a row after the data ends so its easy to see all the summed amounts, so for example say if the data ends in row B35, then the formula should be in B37, then D37, F37 etc
Can this be achieved?