VBA code to sumifs and split across Business Case and Managers

[Balajibenz]

Hi Can someone help me with below requirement.

I have base data in sheet1 with Business Case ID's and Managers etc as below. X to AI columns will have Jan to Dec data. I am only allowed to present some sample data due to confidentiality.

X	Y	AI	AJ	AM	AN
1-Jan​	2-Feb​	12-Dec​	Yes/No	Manager	Business Case
43​	27​	0​	Yes	Robert	3124​
11​	21​	14​	Yes	Amit	3124​
122​	140​	63​	No	Robert	238​
0​	39​	27​	Yes	Amit	238​

In sheet2 i am looking for the following view where for each manager there will be some Business Cases listed under them and for the each business case and for the each month data it should be displayed for Yes and No from column AJ from sheet1.

Manager
Robert		Jan'22	Feb'22
	Yes	No	Yes	No
3124	Hrs	43	0	27	0
	%	100%	0%	100%	0%
238	Hrs	0	122		140
	%	0%	100%	0%	100%
Amit		Jan'22	Feb'22
	Yes	No	Yes	No
3124	Hrs	11		21
	%	100%	0%	100%	0%
238	Hrs	0		39
	%	#DIV/0!	#DIV/0!	100%	0%

Manager data cell and Business case cell are are respectively merged with the empty cells right below them.

The original data is huge and in sheet2 each manager will have around 20 business cases under them so for each business case code should bring up Yes and No split for each month from Jan to Dec. it is working with sumifs formula but it is taking a lot of time and i am trying to automate it to reduce the time.

Thank you in advance and it would be of great help if someone help mw on this.