Help to Create VBA codes as per all Category

Refer my attachment file.

In this sheet name-Category which is final.

I have attempted an excel sheet working i.e. Variance Qtr Wise and apply an excel formula .

File has been very slow to save responded.

Please help me to cretae VBA codes for that Automation includes all category.

Format will be no same as shown in sheet 1.may be includes one or more sheet but category wise VBA codes.

Is it possible in this VBA era ?

Use the following

in C5

=SUMIFS(Dump!$H:$H,Dump!$B:$B,$C$3,Dump!$F:$F,$C$2,Dump!$Q:$Q,$B5)

in E5

=SUMIFS(Dump!$O:$O,Dump!$B:$B,$C$3,Dump!$F:$F,$C$2,Dump!$Q:$Q,$B5)/10^7

in F5

=SUMIFS(Dump!$H:$H,Dump!$B:$B,$F$3,Dump!$F:$F,$F$2,Dump!$Q:$Q,$B5)

in H5

=SUMIFS(Dump!$O:$O,Dump!$B:$B,$F$3,Dump!$F:$F,$F$2,Dump!$Q:$Q,$B5)/10^7

Repeat the above for the other SUMPRODUCT formulas (C42,D55 etc)

Thanks for the help.

If you are happy with the solution, please mark as SOLVED: see "Thread Tools" at top of page.