VBA to fill the formula across row and column till total

Dear expert

i have set of table range which need to fill formula across row and column depends upon header of column and adjust of rows ends

c5 have formula =SUMIFS(RSS!$B:$B,RSS!$A:$A,C$4,RSS!$C:$C,$B5) it has to fill towards right till total and fill down till adjacent row of B5:B.

i have vba till across column but it does not work for total i want new code to fill across row and column end with total

Please Login or Register  to view this content.

find the attachment.

Try with this 1

Please Login or Register  to view this content.

Kind regards
Leo

Amazing Sir make better simple can u fill the range directly with formula instead of fill from C5

formula =SUMIFS(RSS!$B:$B,RSS!$A:$A,C$4,RSS!$C:$C,$B5), can u help at last requirement sir?

Looks like this then

Please Login or Register  to view this content.

Kind regards
Leo

Amazing Sir Solved Thanks for being spend your valuable time for me!!