I am working on excel 2007 macros where i have to select data in first column from range 0 to 300 , 300 to 600, 600 to 900 and so on incrementing 300. where the values of column H with respect to 0 to 300 should be sum and transfer to sheet2 and sum of values of 300 to 600 of H column transfered to sheet2 for all such cases.It is described well in the picture, i wish to create a button in excel macro by pressing it transfer all data summing to sheet2.
excel question.png