HI I need help with vba code to do the following :
in the below snapshot i need to populate SUMIF formula in column C and i need to populate SUM formula for each category .
Eg : range C2,C3,C4 =sumif(Formula) and C5 should be sum(C2:c4) and D5 = Sumif(Formula)
similarly for the next category C9,C10......C15 = sumif(formula) and C16= sum(C9:C15) & D16 = = Sumif(Formula) and same goes on for the next category as well.
is it possible to do in vba ? can anyone help.. Thank you in advance.
in the below snapshot i need to populate SUMIF formula in column C and i need to populate SUM formula for each category .
Eg : range C2,C3,C4 =sumif(Formula) and C5 should be sum(C2:c4) and D5 = Sumif(Formula)
similarly for the next category C9,C10......C15 = sumif(formula) and C16= sum(C9:C15) & D16 = = Sumif(Formula) and same goes on for the next category as well.
is it possible to do in vba ? can anyone help.. Thank you in advance.