VBA to fill the different range with formula depends upon row of header value ends

Dear experts

I have four types table range In which i have to fill the formula depends upon row and column header labels the tables row and column labels values the raw data has connect to get result in sumifs and count ifs function i want fill the formula till header values ends up in each range.


Table1 Start at C5=SUMIFS(Rawdata!$G:$G,Rawdata!$D:$D,$B5,Rawdata!$A:$A,C$4)-SUMIFS(Rawdata!$I:$I,Rawdata!$C:$C,$A5,Rawdata!$A:$A,C$4) end till row 4 header
Table2 Start at C20=SUMIFS(Rawdata!$H:$H,Rawdata!$C:$C,$B20) end till row header 19
Table3 start at C31=SUMIFS(Rawdata!$I:$I,Rawdata!$E:$E,$B31,Rawdata!$C:$C,C$30) It might get extent depends upon row text value in row 30 in the row 31 the formula has to fill
Table4 COUNTIFS(Rawdata!$J:$J,$V4,Rawdata!$B:$B,W$3) Till end of row header 3



find the attachment. you may understand what i looking for.

Dear sir Thanks alot!! You are amazing ,You made my day Solved 100%
Ya I done

Please Login or Register  to view this content.